Archive

Archive for the ‘Scheduler’ Category

Monitor Oracle Scheduler Jobs

December 9, 2011 Leave a comment

Job status and run count:

select
 job_name, owner,
 nvl(to_char(next_run_date, 'DD-MON-YYYY HH24:MI:SS'),
 schedule_name) as next_run_date,
 to_char(last_start_date, 'DD-MON-YYYY HH24:MI:SS') as last_run_date,
 job_class, run_count
from dba_scheduler_jobs;

Reference Links: