← 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