How Can I See Running Job In Oracle Database

Buğra PARLAYAN

1 year ago

We can see Running Job in Oracle Database using below code block.

SELECT JOB_NAME,
         comments,
         job_Action,
         last_start_date,
         last_run_duration,
         state
    FROM dba_scheduler_jobs
   WHERE state = 'RUNNING'
ORDER BY last_start_date DESC;

SELECT JOB_NAME,

comments,

job_Action,

last_start_date,

last_run_duration,

state

FROM dba_scheduler_jobs

WHERE state = 'RUNNING'

ORDER BY last_start_date DESC;