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;
