ALL_SCHEDULER_JOB_CLASSES

ALL_SCHEDULER_JOB_CLASSES displays information about the Scheduler job classes accessible to the current user.

DBA_SCHEDULER_JOB_CLASSES displays information about all Scheduler job classes in the database.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL Owner of the Scheduler job class
JOB_CLASS_NAME VARCHAR2(128) NOT NULL Name of the Scheduler job class
RESOURCE_CONSUMER_GROUP VARCHAR2(128)   Resource consumer group associated with the class
SERVICE VARCHAR2(64)   Name of the service the class is associated with
LOGGING_LEVEL VARCHAR2(11)  

Amount of logging that will be done pertaining to the class:

  • OFF

  • RUNS

  • FAILED RUNS

  • FULL

LOG_HISTORY NUMBER   History (in days) to maintain in the job log for the class
COMMENTS VARCHAR2(4000)   Comments on the class

See Also: “DBA_SCHEDULER_JOB_CLASSES”