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

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

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 later versions, they now show as ABORTED.

The OAE jobs status is now shown in the so_application_status column in the so_job_queue table.

Resolution

You can create a subvar with the following sql statement in it.
 
select so_application_status from so_job_queue where so_jobid={jobid}

not that {jobid} is a replacement value
 
Then put an after condition on the job.
 
 AFTER ONCE {<subvar>} = Warning SET FINISHED STATUS FINISHED


Aditionally, you can add the so_application_status field to the backlog by Clicking on Options > Tables > Backlog.