Class

The class definition identifies the resource consumer group to which the job belongs, so we are not required to use Resource Manager. However, for the processes we want to manage, we have to use Resource Manager and couple them to a job_class that has a resource consumer group mapping. Here we define the job classes and map them to a previously defined group:

--/
begin
DBMS_SCHEDULER.CREATE_JOB_CLASS
(
JOB_CLASS_NAME => 'sub_1s',
LOGGING_LEVEL  => DBMS_SCHEDULER.LOGGING_FULL,
LOG_HISTORY    => 5,
RESOURCE_CONSUMER_GROUP => 'batch_sub_1s'
);
DBMS_SCHEDULER.CREATE_JOB_CLASS
(
JOB_CLASS_NAME => 'sub_1m',
LOGGING_LEVEL  => DBMS_SCHEDULER.LOGGING_FULL,
LOG_HISTORY    => 5,
RESOURCE_CONSUMER_GROUP => 'batch_sub_1m'
);
DBMS_SCHEDULER.CREATE_JOB_CLASS
(
JOB_CLASS_NAME => 'sub_1h',
LOGGING_LEVEL  => DBMS_SCHEDULER.LOGGING_FULL,
LOG_HISTORY    => 5,
RESOURCE_CONSUMER_GROUP => 'batch_sub_1h'
);
DBMS_SCHEDULER.CREATE_JOB_CLASS
(
JOB_CLASS_NAME => 'longer...