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.DBA_SCHEDULER_RUNNING_CHAINS

Object Details

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

All steps of all running chains in the database

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
OWNER	VARCHAR2	(128)	Yes	Owner of the job which is running the chain
JOB_NAME	VARCHAR2	(128)	Yes	Name of the job which is running the chain
JOB_SUBNAME	VARCHAR2	(128)		Subname of the job which is running the chain (for a subchain)
CHAIN_OWNER	VARCHAR2	(128)	Yes	Owner of the chain being run
CHAIN_NAME	VARCHAR2	(128)	Yes	Name of the chain being run
STEP_NAME	VARCHAR2	(128)	Yes	Name of this step of the running chain
STATE	VARCHAR2	(15)		State of this step
ERROR_CODE	NUMBER			Error code of this step, if it has finished running
COMPLETED	VARCHAR2	(5)		Whether this step has completed
START_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		When this step started, if it has already started
END_DATE	TIMESTAMP(6) WITH TIME ZONE	(13)		When this job step finished running, if it has finished running
DURATION	INTERVAL DAY(9) TO SECOND(6)	(11)		How long this step took to complete, if it has completed
SKIP	VARCHAR2	(5)		Whether this step will be skipped or not
PAUSE	VARCHAR2	(5)		Whether this step will be paused after running or not
PAUSE_BEFORE	VARCHAR2	(5)		Whether this step will be paused before running or not
RESTART_ON_RECOVERY	VARCHAR2	(5)		Whether this step will be restarted on database recovery
RESTART_ON_FAILURE	VARCHAR2	(5)		Whether this step should be retried on application failure
STEP_JOB_SUBNAME	VARCHAR2	(128)		Subname of the job running this step, if the step job has been created
STEP_JOB_LOG_ID	NUMBER			Log id of the step job if it has completed and has been logged.

Query Text

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


SELECT OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      CHAIN_OWNER
,      CHAIN_NAME
,      STEP_NAME
,      STATE
,      ERROR_CODE
,      COMPLETED
,      START_DATE
,      END_DATE
,      DURATION
,      SKIP
,      PAUSE
,      PAUSE_BEFORE
,      RESTART_ON_RECOVERY
,      RESTART_ON_FAILURE
,      STEP_JOB_SUBNAME
,      STEP_JOB_LOG_ID
FROM SYS.DBA_SCHEDULER_RUNNING_CHAINS;

Dependencies

[top of page]

SYS.DBA_SCHEDULER_RUNNING_CHAINS references the following:

SYS: OBJ$; SCHEDULER$_JOB; SCHEDULER$_STEP; SCHEDULER$_STEP_STATE; USER$

SYS.DBA_SCHEDULER_RUNNING_CHAINS is referenced by following:

PUBLIC: DBA_SCHEDULER_RUNNING_CHAINS
SYS: DBMS_ISCHED - show dependent code