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