← Scheduler & Jobs
Oracle · Scheduler & Jobs

How to find currently running scheduler jobs in Oracle

See which DBMS_SCHEDULER jobs are running right now, joined to V$SESSION for the SID, user, machine, and elapsed time.

Tested on11g12c18c19c21c23ai26ai

Show Scheduler jobs running right now, joined to V$SESSION for the session, user, machine, and elapsed time.

SELECT r.owner, r.job_name, r.session_id, r.elapsed_time,
       s.serial#, s.username, s.status, s.machine
FROM   dba_scheduler_running_jobs r
LEFT JOIN v$session s ON s.sid = r.session_id
ORDER  BY r.elapsed_time DESC;
DBMS_SCHEDULERSchedulerV$SESSION