How to get list of jobs in a chain in initiated status?

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

All the modules of the chain are completed but the chain status is not changed from Initiated to Finished.

Is there any way to get the chain list that is in the Initiated state but the modules are in finished status?

Environment

Release: 9.x

Resolution

There are 2 tables which store condition information. These tables are so_job_cond and so_object_cond.

The so_object_cond table contains records for condition definitions. This means conditions as defined at the module, chain header, and component level. These are associated with an object sequence number, not a job sequence number. They contain pre-evaluated values (i.e. #today instead of 07-25-2011). This table contains two so_object_types, M and C. In 4. x this stood for module and component. However, now you can have conditions on chain headers so it's easier to think of it in terms of what tables they connect to:

M - so_job_table for Module and Chain header conditions. so_object_cond.so_object_seq=so_job_table.so_job_seq
C - so_chain_detail for Component conditions. so_object_cond.so_object_seq=so_chain_detail.so_det_seq

The so_job_cond table contains run-time conditions. This means conditions linked to a jobid in backlog or history. They typically contain evaluated values. All entries in this table should have an object type of J as there is a trigger on insert to add J to this field. It does not really signify anything in this table as all entries have the same type. It stands for Job, as this table is for evaluated Job conditions. This table is linked to so_job_queue or so_job_history (depending on whether or not the job is in backlog or history yet) and is cleaned up by the SYSTEM chain based on Jobid, not the J flag.

so_job_cond.so_object_seq=so_job_history.so_jobid