Is there any way to run a query against Oracle DB to find out if a job is in a chain or not?
Applications Manager: 9.x
The easiest way to find out if a Job is used in a Chain is to do it from the Java client by selecting the Job from the Job selector Window and selecting the Usage button.
For SQL there are two tables related to the request; the so_job_table which holds the Job name or Process Flow name and the so_chain_detail table which is the table that holds on the component objects.
Here is the SQL statement:
select a.so_module as "Job Name", b.so_task_name as "Component Alias", a.so_command_type as "CHAIN or JOB"
from so_job_table a, so_chain_detail b