eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.ALL_SCHEDULER_CHAIN_STEPS

Object Details

Object Name:	ALL_SCHEDULER_CHAIN_STEPS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

All steps of scheduler chains visible to the current user

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the scheduler chain the step is in
CHAIN_NAME	VARCHAR2	(128)	Yes	Name of the scheduler chain the step is in
STEP_NAME	VARCHAR2	(128)	Yes	Name of the chain step
PROGRAM_OWNER	VARCHAR2	(392)		Owner of the program that runs during this step
PROGRAM_NAME	VARCHAR2	(392)		Name of the program that runs during this 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 source queue into which event will be raised
EVENT_QUEUE_NAME	VARCHAR2	(128)		Name of source queue into which event will be raised
EVENT_QUEUE_AGENT	VARCHAR2	(128)		Name of AQ agent used by user on the event source queue (for a secure queue)
EVENT_CONDITION	VARCHAR2	(4000)		Boolean expression used as the subscription rule for 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)		Whether this step should be skipped or not
PAUSE	VARCHAR2	(5)		Whether this step should be paused after running or not
PAUSE_BEFORE	VARCHAR2	(5)		Whether this step should be paused before running or not
RESTART_ON_RECOVERY	VARCHAR2	(5)		Whether this step should be restarted on database recovery
RESTART_ON_FAILURE	VARCHAR2	(5)		Whether this step should be retried on application failure
STEP_TYPE	VARCHAR2	(21)		Type of this step
TIMEOUT	INTERVAL DAY(3) TO SECOND(0)	(11)		Timeout for waiting on an event schedule

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      CHAIN_NAME
,      STEP_NAME
,      PROGRAM_OWNER
,      PROGRAM_NAME
,      EVENT_SCHEDULE_OWNER
,      EVENT_SCHEDULE_NAME
,      EVENT_QUEUE_OWNER
,      EVENT_QUEUE_NAME
,      EVENT_QUEUE_AGENT
,      EVENT_CONDITION
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      DESTINATION
,      SKIP
,      PAUSE
,      PAUSE_BEFORE
,      RESTART_ON_RECOVERY
,      RESTART_ON_FAILURE
,      STEP_TYPE
,      TIMEOUT
FROM SYS.ALL_SCHEDULER_CHAIN_STEPS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_CHAIN_STEPS references the following:

SYS: OBJ$; OBJAUTH$; SCHEDULER$_STEP; USER$

SYS.ALL_SCHEDULER_CHAIN_STEPS is referenced by following:

PUBLIC: ALL_SCHEDULER_CHAIN_STEPS
SYS: DBMS_SCHEDULER - show dependent code