search cancel

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

book

Article ID: 90121

calendar_today

Updated On:

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 .