DBA_JOBS_RUNNING
All jobs in the database which are currently running, join v$lock and job$Columns
___________________________
THIS_DATE
Date that this job started executing (usually null if not executing)
SID
Identifier of process which is executing the job. See v$lock.
JOB
Identifier of job. This job is currently executing.
FAILURES
How many times has this job started and failed since its last success?
LAST_DATE
Date that this job last successfully executed
THIS_SEC
Same as THIS_DATE. This is when the last successful execution started.
LAST_SEC
Same as LAST_DATE. This is when the last successful execution started.
INSTANCE
The instance number restricted to run the job
Related Commands: