select JOB, WHAT, THIS_DATE, THIS_SEC, NEXT_DATE, NEXT_SEC, BROKEN, INTERVAL, FAILURES from dba_jobs
where 1 = 1 AND WHAT like '%%'