CODE EXAMPLE FOR SQL

oracle list chain steps

SELECT STEP_NAME,
       PROGRAM_NAME,
       STEP_TYPE
FROM DBA_SCHEDULER_CHAIN_STEPS
WHERE CHAIN_NAME = 'MY_CHAIN';