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