How to change status of a OAE job in Warning to FINISHED using a condition

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

How to change status of a OAE job in Warning to FINISHED using a condition

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

Resolution

Detailed Description and Symptoms

In earlier versions of Applications Manager OAE jobs would show the Oracle applications status of C-RUNNING, C-NORMAL, C-ERROR, and C-WARNING in the backlog. In 8.0 they now show as ABORTED.

Investigation

This was a change in functionality in 7.1, and 8.0. The OAE jobs status is now shown in the so_application_status column in the so_job_queue table.

Solution

You can create a subvar with the following sql statement in it.
 
 select so_application_status from so_job_queue where so_jobid={jobid} ( {jobid} is a replaement value)
 
 Then put an after condition on the job.
 
 AFTER ONCE {<subvar>} = Warning SET FINISHED STATUS FINISHED
 
 You can add the so_application_status field to the backlog by Clicking on Options > Tables > Backlog .