OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043

12.9. Using Scheduler Views

Oracle offers a wide variety of views to access information regarding the Scheduler and its associated objects. These views allow you to see information about currently running jobs and past runs of jobs. Table 12.6 describes the available Scheduler views.

To see information on completed instances of a job, use the example shown here:

SQL> select job_name, status, error#
  2  from dba_scheduler_job_run_details
  3  where job_name = 'FAIL_JOB';

JOB_NAME STATUS           ERROR#
-------- --------------   ------
FAIL_JOB FAILURE           20000

To see the current state of all jobs, use the following example:

SQL> select job_name, state
  2  from dba_scheduler_jobs; JOB_NAME STATE ----------------- --------------- PURGE_LOG SCHEDULED GATHER_STATS_JOB ...