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

VIEW: SYS.CDB_JOBS_RUNNING

Object Details
Object Name: CDB_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$ in all containers

[View Source]

Columns
Name Datatype Length Mandatory 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
CON_ID NUMBER

container id
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
,      CON_ID
FROM SYS.CDB_JOBS_RUNNING;

Dependencies

[top of page]

SYS.CDB_JOBS_RUNNING does not reference any database object

SYS.CDB_JOBS_RUNNING is referenced by following:

SchemaPUBLIC
SynonymCDB_JOBS_RUNNING