The CREATE_JOB_CLASS procedure creates a job class.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not provide the Oracle mode.
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 logging level. |
| log_history | The retention period of logs, in days. |
| comments | The comments on 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)