The DROP_JOB_CLASS procedure drops 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.DROP_JOB_CLASS ( job_class_name IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE);
Parameters
| Parameter | Description |
|---|---|
| job_class_name | The name of the job class. |
| force | This parameter can be set only to false. If you call the DROP_JOB_CLASS procedure to drop a job class associated with a job, the call fails with an error returned. |
Examples
obclient> BEGIN
-> DBMS_SCHEDULER.DROP_JOB_CLASS(
-> job_class_name => 'my_job_class'
-> );
-> END;
-> /
Query OK, 1 row affected (0.021 sec)