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_JOBS_RUNNING

Object Details

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

All jobs in the database which are currently running, join v$lock and job$

[View Source]

Columns

Name	Datatype	Length	Comments
SID	NUMBER		Identifier of process which is executing the job. See v$lock.
JOB	NUMBER		Identifier of job. This job is currently executing.
FAILURES	NUMBER		How many times has this job started and failed since its last success?
LAST_DATE	DATE		Date that this job last successfully executed
LAST_SEC	VARCHAR2	(8)	Same as LAST_DATE. This is when the last successful execution started.
THIS_DATE	DATE		Date that this job started executing (usually null if not executing)
THIS_SEC	VARCHAR2	(8)	Same as THIS_DATE. This is when the last successful execution started.
INSTANCE	NUMBER		The instance number restricted to run the job

Query Text

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


SELECT SID
,      JOB
,      FAILURES
,      LAST_DATE
,      LAST_SEC
,      THIS_DATE
,      THIS_SEC
,      INSTANCE
FROM SYS.DBA_JOBS_RUNNING;

Dependencies

[top of page]

SYS.DBA_JOBS_RUNNING references the following:

SYS: JOB$

SYS.DBA_JOBS_RUNNING is referenced by following:

PUBLIC: DBA_JOBS_RUNNING