Oracle Tips by Burleson

Oracle 10g Scheduler Overview

TABLE_NAME
------------------------------
SCHEDULER$_JOB_RUN_DETAILS
SCHEDULER$_JOB_STEP_STATE
AQ$_SCHEDULER$_JOBQTAB_S
SCHEDULER$_JOB
SCHEDULER$_JOBQTAB
SCHEDULER$_JOB_ARGUMENT
SCHEDULER$_JOB_CHAIN
SCHEDULER$_JOB_STEP
AQ$_SCHEDULER$_JOBQTAB_G
AQ$_SCHEDULER$_JOBQTAB_H
AQ$_SCHEDULER$_JOBQTAB_I
AQ$_SCHEDULER$_JOBQTAB_T

12 rows selected.

In addition to the conceptual job table, the scheduler uses several other tables to store metadata about scheduler objects.

select
   table_name
from
   user_tables
SEE CODE DEPOT FOR FULL SCRIPT
;