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_RUNNING_JOBS

Object Details

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

[View Source]

Columns

Name	Datatype	Length	Comments
OWNER	VARCHAR2	(128)	Owner of the running scheduler job
JOB_NAME	VARCHAR2	(128)	Name of the running scheduler job
JOB_SUBNAME	VARCHAR2	(128)	Subname of the running scheduler job (for a job running a chain step)
JOB_STYLE	VARCHAR2	(17)	Job style - regular, lightweight or volatile
DETACHED	VARCHAR2	(5)
SESSION_ID	NUMBER
SLAVE_PROCESS_ID	NUMBER		Process number of the slave process running the scheduler job
SLAVE_OS_PROCESS_ID	VARCHAR2	(12)	Operating system process number of the slave process running the scheduler job
RUNNING_INSTANCE	NUMBER		Database instance number of the slave process running the scheduler job
RESOURCE_CONSUMER_GROUP	VARCHAR2	(32)	Resource consumer group of the session in which the scheduler job is running
ELAPSED_TIME	INTERVAL DAY(3) TO SECOND(2)	(11)	Time elapsed since the scheduler job started
CPU_USED	INTERVAL DAY(3) TO SECOND(2)	(11)	CPU time used by the running scheduler job, if available
DESTINATION_OWNER	VARCHAR2	(128)	Owner of destination object (if used) else NULL
DESTINATION	VARCHAR2	(128)	Destination that this job is running on
CREDENTIAL_OWNER	VARCHAR2	(128)	Owner of login credential used for this running job, if any
CREDENTIAL_NAME	VARCHAR2	(128)	Name of login credential used for this running job, if any
LOG_ID	NUMBER		Log id that will be used for this job run

Query Text

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


SELECT OWNER
,      JOB_NAME
,      JOB_SUBNAME
,      JOB_STYLE
,      DETACHED
,      SESSION_ID
,      SLAVE_PROCESS_ID
,      SLAVE_OS_PROCESS_ID
,      RUNNING_INSTANCE
,      RESOURCE_CONSUMER_GROUP
,      ELAPSED_TIME
,      CPU_USED
,      DESTINATION_OWNER
,      DESTINATION
,      CREDENTIAL_OWNER
,      CREDENTIAL_NAME
,      LOG_ID
FROM SYS.ALL_SCHEDULER_RUNNING_JOBS;

Dependencies

[top of page]

SYS.ALL_SCHEDULER_RUNNING_JOBS references the following:

SYS: OBJ$; OBJAUTH$; SCHEDULER$_COMB_LW_JOB; SCHEDULER$_JOB; SCHEDULER$_LWJOB_OBJ; SCHEDULER$_PROGRAM; USER$

SYS.ALL_SCHEDULER_RUNNING_JOBS is referenced by following:

PUBLIC: ALL_SCHEDULER_RUNNING_JOBS