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

Related View

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

Column Datatype NULL Description
JOB_CLASS_NAME VARCHAR2(30) NOT NULL Name of the Scheduler job class
RESOURCE_CONSUMER_GROUP VARCHAR2(30)   Resource consumer group associated with the class
SERVICE VARCHAR2(64)   Name of the service the class is associated with
LOGGING_LEVEL VARCHAR2(4)   Amount of logging that will be done pertaining to the class:
  • OFF

  • RUNS

  • FULL

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