DBA_JOBS_RUNNING

5.135 DBA_JOBS_RUNNING

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

Column	Datatype	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`.