Skip Headers
Oracle® Database Reference
10g Release 2 (10.2)

Part Number B14237-02
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
View PDF

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

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