How to check the progress of created Job Scheduler objects in Oracle database.

The Progress of these Objects within the database can be verified by using the following Queries.

–To view Scheduler database objects

SELECT
owner
,object_type
,object_name
,created
,status
FROM dba_objects
WHERE object_type IN (‘PROGRAM’, ‘JOB’, ‘JOB CLASS’, ‘SCHEDULE’, ‘WINDOW’)
ORDER BY object_type, OBJECT_name;

–To view scheduled objects

SELECT
owner
,schedule_name
,to_char(start_date, ‘mm/dd/yyyy hh24:mi:ss’) start_date
,to_char(end_date, ‘mm/dd/yyyy hh24:mi:ss’) end_date
,repeat_interval
FROM dba_scheduler_schedules;

— To view what program objects are available?

SELECT
owner
,program_name
,program_type
,program_action
FROM dba_scheduler_programs;

— To view what Job objects are available?

SELECT
owner
,job_name
,state
,job_class
,job_type
,job_action
FROM dba_scheduler_jobs;

— To view Failed Scheduled Tasks

SELECT
log_id
,log_date
,owner
,job_name
,status
,actual_start_date
,error#
FROM dba_scheduler_job_run_details
WHERE status <> ‘SUCCEEDED’
ORDER BY actual_start_date;

–To View Job components

SELECT
owner
,job_name
,program_name
,schedule_name
,enabled
,state
,restartable
,start_date
FROM dba_scheduler_jobs;

— To view Job Arguments

SELECT
job_name
,argument_name
,argument_position
,value
FROM dba_scheduler_job_args;

–T view Scheduled Tasks History

SELECT
log_id
,log_date
,owner
,job_name
,status
FROM dba_scheduler_job_log;

— Scheduled Tasks Running Right Now

SELECT
owner
,job_name
,session_id
,running_instance
,elapsed_time
FROM dba_scheduler_running_jobs;
Advertisements
This entry was posted in Oracle Database and tagged , , , , . Bookmark the permalink.

One Response to How to check the progress of created Job Scheduler objects in Oracle database.

  1. Avik says:

    All the necessary views/tables for Job Scheduling in 1 place, please add “DBA_SCHEDULER_RUNNING_CHAINS” also
    Nice post

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