DBA Data[Home] [Help] [Dependency Information]

VIEW: SYS.CDB_SCHEDULER_JOB_CLASSES

Object Details
Object Name: CDB_SCHEDULER_JOB_CLASSES
Object Type: VIEW
Owner: SYS
Subobject Name:
Status: VALID

All scheduler classes in the database in all containers

[View Source]

Columns
Name Datatype Length Mandatory Comments
OWNER VARCHAR2 (30) Yes Owner of the scheduler class
JOB_CLASS_NAME VARCHAR2 (30) Yes Name of the scheduler class
RESOURCE_CONSUMER_GROUP VARCHAR2 (128)
Resource consumer group associated with the class
SERVICE VARCHAR2 (64)
Name of the service this class is affined with
LOGGING_LEVEL VARCHAR2 (11)
Amount of logging that will be done pertaining to this class
LOG_HISTORY NUMBER

The history to maintain in the job log (in days) for this class
COMMENTS VARCHAR2 (240)
Comments on this class
CON_ID NUMBER

container id
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OWNER
,      JOB_CLASS_NAME
,      RESOURCE_CONSUMER_GROUP
,      SERVICE
,      LOGGING_LEVEL
,      LOG_HISTORY
,      COMMENTS
,      CON_ID
FROM SYS.CDB_SCHEDULER_JOB_CLASSES;

Dependencies

[top of page]

SYS.CDB_SCHEDULER_JOB_CLASSES does not reference any database object

SYS.CDB_SCHEDULER_JOB_CLASSES is referenced by following:

SchemaPUBLIC
SynonymCDB_SCHEDULER_JOB_CLASSES