Oracle Scheduler - Oracle 10g/11g Data and Database Management Utilities - page 222

Several different queries can be issued against the database to monitor the
job activity.

Requirement Query

Details on Job runs select log_date,

job_name,
status,
req_start_date,
actual_start_date,
run_duration
from dba_scheduler_job_run_details;

Running Jobs select job_name,

session_id,
running_instance,
elapsed_time,
cpu_used
from dba_scheduler_running_jobs;

Query Job History select log_date,

job_name,
status
from dba_scheduler_job_log;

Query all schedules select schedule_name,

schedule_type,
start_date,
repeat_interval
from dba_scheduler_schedules;

Query all jobs and their attributes select *

from dba_scheduler_jobs;

Query all programs select *

from dba_scheduler_programs;

Query all program arguments select *

from dba_scheduler_program_args;