3.36 ALL_SCHEDULER_CHAIN_STEPS

ALL_SCHEDULER_CHAIN_STEPS displays information about the defined steps of the chains accessible to the current user (that is, those chains that the user has ALTER or EXECUTE privileges for).

Related Views

  • DBA_SCHEDULER_CHAIN_STEPS displays information about the defined steps of all chains in the database.

  • USER_SCHEDULER_CHAIN_STEPS displays information about the defined steps of the chains owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(128)

NOT NULL

Owner of the Scheduler chain the step is in

CHAIN_NAME

VARCHAR2(128)

NOT NULL

Name of the Scheduler chain the step is in

STEP_NAME

VARCHAR2(128)

NOT NULL

Name of the chain step

PROGRAM_OWNER

VARCHAR2(392)

Owner of the program that runs during the step

PROGRAM_NAME

VARCHAR2(392)

Name of the program that runs during the step

EVENT_SCHEDULE_OWNER

VARCHAR2(392)

Owner of the event schedule that this step waits for

EVENT_SCHEDULE_NAME

VARCHAR2(392)

Name of the event schedule that this step waits for

EVENT_QUEUE_OWNER

VARCHAR2(128)

Owner of the source queue into which the event will be raised

EVENT_QUEUE_NAME

VARCHAR2(128)

Name of the source queue into which the event will be raised

EVENT_QUEUE_AGENT

VARCHAR2(128)

Name of the 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

CREDENTIAL_OWNER

VARCHAR2(128)

Owner of the credential to be used for an external step job

CREDENTIAL_NAME

VARCHAR2(128)

Name of the credential to be used for an external step job

DESTINATION

VARCHAR2(128)

Destination host on which a remote step job will run

SKIP

VARCHAR2(5)

Indicates whether the step should be skipped (TRUE) or not (FALSE)

PAUSE

VARCHAR2(5)

Indicates whether the step should be paused after running (TRUE) or not (FALSE)

PAUSE_BEFORE

VARCHAR2(5)

Indicates whether the step should be paused before running (TRUE) or not (FALSE)

RESTART_ON_RECOVERY

VARCHAR2(5)

Indicates whether the step should be restarted on database recovery (TRUE) or not (FALSE)

RESTART_ON_FAILURE

VARCHAR2(5)

Indicates whether the step should be restarted on application failure (TRUE) or not (FALSE)

STEP_TYPE

VARCHAR2(21)

Type of the step:

  • EVENT_SCHEDULE

  • INLINE_EVENT

  • SUBCHAIN

  • PROGRAM

TIMEOUT

INTERVAL DAY(3) TO SECOND(0)

Timeout for waiting on an event schedule