OracleScheduler & jobs

Legacy DBMS_JOB jobs

Old-style jobs, which still turn up in upgraded databases. From 19c they're implemented as scheduler jobs underneath, but DBA_JOBS still shows them this way.

Not yet verified. How scripts are tested

1CLEAR COLUMNS2SET LINESIZE 160 PAGESIZE 100 TRIMOUT ON TAB OFF3COLUMN job      FORMAT 99999994COLUMN log_user HEADING "OWNER"    FORMAT A155COLUMN broken   FORMAT A66COLUMN failures FORMAT 9,9907COLUMN next_run HEADING "NEXT RUN" FORMAT A168COLUMN what     FORMAT A60 TRUNCATE9 10SELECT job, log_user, broken, failures,11       TO_CHAR(next_date, 'YYYY-MM-DD HH24:MI') AS next_run,12       what13FROM dba_jobs14ORDER BY job;

Save it as ora-dbms-job.sql and run it with SQL> @ora-dbms-job.

Open in denrepoRelated tool: Scheduler job builder

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.
• Scheduler jobs running nowJobs currently executing, the session running each one and how long it has been going.
• 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.