Search notes:

Oracle: DBA_SCHEDULER_CHAIN_STEPS

select
   stp.owner               , stp.chain_name,
   stp.step_name           , stp.step_type,   
   stp.pause               , stp.skip,
   stp.program_owner       , stp.program_name,   
   stp.credential_owner    , stp.credential_name,
   stp.event_queue_owner   , stp.event_queue_name,
   stp.event_schedule_owner, stp.event_schedule_name,   
   stp.event_condition,
   stp.event_queue_agent,
   stp.pause_before,
   stp.restart_on_failure  , stp.restart_on_recovery,
   stp.destination,
   stp.timeout
from
   sys.dba_scheduler_chain_steps stp;

See also

data dictionary

Index