ALL_SCHEDULER_CHAIN_STEPS

ALL_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains visible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

Related Views

DBA_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains in the database.
USER_SCHEDULER_CHAIN_STEPS shows the defined steps of all chains in the current user's schema. This view does not display the OWNER column.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Chain schema
`CHAIN_NAME`	`VARCHAR2(30)`	`NOT NULL`	Chain name
`STEP_NAME`	`VARCHAR2(30)`	`NOT NULL`	Chain step name
`PROGRAM_OWNER`	`VARCHAR2(98)`		Owner of the program that runs during this step
`PROGRAM_NAME`	`VARCHAR2(98)`		Name of the program that runs during this step
`EVENT_SCHEDULE_OWNER`	`VARCHAR2(98)`		Owner of the event schedule that this step waits for
`EVENT_SCHEDULE_NAME`	`VARCHAR2(98)`		Name of the event schedule that this step waits for
`EVENT_QUEUE_OWNER`	`VARCHAR2(30)`		Owner of source queue into which event will be raised
`EVENT_QUEUE_NAME`	`VARCHAR2(30)`		Name of source queue into which event will be raised
`EVENT_QUEUE_AGENT`	`VARCHAR2(30)`		Name of AQ agent used by the user on the event source queue (for a secure queue)
`EVENT_CONDITION`	`VARCHAR2(4000)`		Boolean expression used as the subscription rule for an event on the source queue
`SKIP`	`VARCHAR2(5)`		Whether or not this step should be skipped
`PAUSE`	`VARCHAR2(5)`		Whether or not this step should be paused after running
`RESTART_ON_RECOVERY`	`VARCHAR2(5)`		Whether or not this step should be restarted on database recovery
`STEP_TYPE`	`VARCHAR2(14)`		Type of this step
`TIMEOUT`	`INTERVAL DAY(3) TO SECOND(0)`		Timeout for waiting on an event schedule