broken_jobs.sql
Download Script
set pages 1000 set arraysize 1 select JOB, LOG_USER, LAST_DATE, LAST_SEC, NEXT_DATE, NEXT_SEC, TOTAL_TIME, BROKEN, INTERVAL, FAILURES, WHAT from dba_jobs where broken = 'Y' order by 1;
Download Script
set pages 1000 set arraysize 1 select JOB, LOG_USER, LAST_DATE, LAST_SEC, NEXT_DATE, NEXT_SEC, TOTAL_TIME, BROKEN, INTERVAL, FAILURES, WHAT from dba_jobs where broken = 'Y' order by 1;