|
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: