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 of the Scheduler chain the step is in |
|
|
|
Name of the Scheduler chain the step is in |
|
|
|
Name of the chain step |
|
|
Owner of the program that runs during the step |
|
|
|
Name of the program that runs during the step |
|
|
|
Owner of the event schedule that this step waits for |
|
|
|
Name of the event schedule that this step waits for |
|
|
|
Owner of the source queue into which the event will be raised |
|
|
|
Name of the source queue into which the event will be raised |
|
|
|
Name of the AQ agent used by the user on the event source queue (for a secure queue) |
|
|
|
Boolean expression used as the subscription rule for an event on the source queue |
|
|
|
Owner of the credential to be used for an external step job |
|
|
|
Name of the credential to be used for an external step job |
|
|
|
Destination host on which a remote step job will run |
|
|
|
Indicates whether the step should be skipped ( |
|
|
|
Indicates whether the step should be paused after running ( |
|
|
|
Indicates whether the step should be paused before running ( |
|
|
|
Indicates whether the step should be restarted on database recovery ( |
|
|
|
Indicates whether the step should be restarted on application failure ( |
|
|
|
Type of the step:
|
|
|
|
Timeout for waiting on an event schedule |
See Also: