Home > Oracle, Scheduler > Monitor Oracle Scheduler Jobs

Monitor Oracle Scheduler Jobs

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:

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: