DBA_JOBS_RUNNING

DBA_JOBS_RUNNING lists all jobs that are currently running in the instance.


Column Datatype NULL Description

SID

NUMBER

 

Identifier of process that is executing the job. See "V$LOCK".

JOB

NUMBER

 

Identifier of job. This job is currently executing.

FAILURES

NUMBER

 

Number of times 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.

THIS_SEC

VARCHAR2(8)

 

Same as THIS_DATE. This is when the last successful execution started.

INSTANCE

NUMBER

 

Indicates which instance can execute or is executing the job; the default is 0.