OracleScheduler & jobs

Scheduler jobs running now

Jobs currently executing, the session running each one and how long it has been going.

Not yet verified. How scripts are tested

ora-sched-running.sql

1CLEAR COLUMNS2SET LINESIZE 140 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN owner      FORMAT A154COLUMN job_name   HEADING "JOB"     FORMAT A355COLUMN session_id HEADING "SID"     FORMAT 9999996COLUMN elapsed    HEADING "ELAPSED" FORMAT A287COLUMN cpu        HEADING "CPU"     FORMAT A288 9SELECT owner, job_name, session_id,10       TO_CHAR(elapsed_time) AS elapsed,11       TO_CHAR(cpu_used) AS cpu12FROM dba_scheduler_running_jobs13ORDER BY elapsed_time DESC;

Save it as ora-sched-running.sql and run it with SQL> @ora-sched-running.

Open in denrepo

More Oracle scripts: Scheduler & jobs

Scheduler job failures in the last 24 hoursEvery job run that didn't succeed, with the error number and the start of the error text.
Application scheduler jobs and next runNon-Oracle scheduler jobs with their state, last and next run, and failure count. Disabled or BROKEN jobs stand out at a glance.
Legacy DBMS_JOB jobsOld-style jobs, which still turn up in upgraded databases. From 19c they're implemented as scheduler jobs underneath, but DBA_JOBS still shows them…