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