Job Scheduling

1. List Scheduled jobs

set lines 100 pages 999
col	schema_user format a15
col	fails format 999
select	job
,	schema_user
,	to_char(last_date, 'hh24:mi dd/mm/yy') last_run
,	to_char(next_date, 'hh24:mi dd/mm/yy') next_run
,	failures fails
,	broken
,	substr(what, 1, 15) what
from	dba_jobs
order by 4
/

Leave a Reply

Your email address will not be published. Required fields are marked *