Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-08
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

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

Column Datatype NULL Description
OWNER VARCHAR2(30) NOT NULL Owner of the Scheduler chain the step is in
CHAIN_NAME VARCHAR2(30) NOT NULL Name of the Scheduler chain the step is in
STEP_NAME VARCHAR2(30) NOT NULL Name of the chain step
PROGRAM_OWNER VARCHAR2(98)   Owner of the program that runs during the step
PROGRAM_NAME VARCHAR2(98)   Name of the program that runs during the 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 the source queue into which the event will be raised
EVENT_QUEUE_NAME VARCHAR2(30)   Name of the source queue into which the event will be raised
EVENT_QUEUE_AGENT VARCHAR2(30)   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(30)   Owner of the credential to be used for an external step job
CREDENTIAL_NAME VARCHAR2(30)   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_BEFOREFoot 1  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(14)   Type of the step:
  • EVENT_SCHEDULE

  • INLINE_EVENT

  • SUBCHAIN

  • PROGRAM

TIMEOUT INTERVAL DAY(3) TO SECOND(0)   Timeout for waiting on an event schedule

Footnote 1 This column is available starting with Oracle Database 11g Release 2 (11.2.0.2).