Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

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;