The CREATE_JOB_CLASS procedure is used to create a job class.
Applicability
This topic applies only to Oracle tenants of OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_SCHEDULER.CREATE_JOB_CLASS( job_class_name IN VARCHAR2,
resource_consumer_group IN VARCHAR2 DEFAULT NULL,
service IN VARCHAR2 DEFAULT NULL,
logging_level IN VARCHAR2 DEFAULT 'RUNS',
log_history IN PLS_INTEGER DEFAULT NULL,
comments IN VARCHAR2 DEFAULT NULL);
Parameters
| Parameter | Description |
|---|---|
| job_class_name | The name of the job class. |
| resource_consumer_group | The name of the resource consumer group associated with the job class. |
| logging_level | The log recording level parameter. |
| log_history | The number of days to retain logs. |
| comments | The text comment describing the job class. |
Examples
obclient> BEGIN
-> DBMS_SCHEDULER.CREATE_JOB_CLASS (
-> job_class_name => 'my_job_class',
-> resource_consumer_group => 'DEFAULT_CONSUMER_GROUP',
-> logging_level => DBMS_SCHEDULER.LOGGING_RUNS,
-> comments => 'This is my custom job class for specific tasks'
-> );
-> END;
-> /
Query OK, 1 row affected (0.038 sec)