@Steven_Nguyen_130 I wrote a similar query -
select jh.SO_PARENT_NAME, jh.so_module, jh.SO_CHAIN_ORDER, jh.SO_START_DATE, jh.SO_JOB_STARTED, jh.SO_JOB_FINISHED, jh.SO_STATUS_NAME, cd.so_predecessors
from appworx.so_job_history jh
INNER JOIN appworx.so_chain_detail cd
ON cd.so_job_seq = jh.so_job_seq
INNER JOIN appworx.so_job_table jt
ON jt.so_job_seq = cd.so_chain_seq
WHERE jh.so_request_date = to_timestamp('Job Req Date')
and SO_PARENT_NAME = 'Your-Chain-Name'
But the query is not giving the actual job names. It just gives the job names from the chain detail table (components of chain) but does not give actual job names that may be part of those chain components / sub-chains. It is just repeating the sub-chain name multiple times. Can someone help here.
Regards,
Shashank Singh
Original Message:
Sent: 12-23-2015 08:00 AM
From: Steven Nguyen
Subject: AM v8: Extracting jobs and their specific predecessors
Alan,
Is this what you are looking for?
Alter session set NLS_DATE_FORMAT = 'DD-MM-YYYY HH24:MI:SS';
SELECT
b.SO_PARENT_NAME,
b.so_module,
b.SO_CHAIN_ORDER,
b.SO_START_DATE,
b.SO_JOB_STARTED,
b.SO_JOB_FINISHED,
b.SO_STATUS_NAME,
a.so_predecessors
FROM so_chain_detail a, so_job_history b
WHERE b.SO_PARENT_NAME = 'TEST_PRED'
AND a.so_job_seq = b.so_job_seq
ORDER BY 3,2;