Let's have a look on how to create a job class..
Using job classes helps you prioritize jobs by allocating resources differently among the various jobs.
All job classes are created in the SYS schema.
All job classes are created in the SYS schema.
Here, the SQL for creating the job class:
BEGIN
sys.dbms_scheduler.create_job_class(
logging_level => DBMS_SCHEDULER.LOGGING_RUNS,
log_history => 5,
resource_consumer_group => 'DEFAULT_CONSUMER_GROUP',
service => 'ocm11g',
comments => 'just a test class',
job_class_name => '"TEST_JOB_CLASS"');
END;
BEGIN
sys.dbms_scheduler.create_job_class(
logging_level => DBMS_SCHEDULER.LOGGING_RUNS,
log_history => 5,
resource_consumer_group => 'DEFAULT_CONSUMER_GROUP',
service => 'ocm11g',
comments => 'just a test class',
job_class_name => '"TEST_JOB_CLASS"');
END;
Now, I will create job using this job class:
Here, the SQL:
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"TEST"."TEST_JOB"',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
-- Insert PL/SQL code here
end;',
start_date => systimestamp at time zone 'Europe/Vienna',
job_class => '"TEST_JOB_CLASS"',
comments => 'just a test job',
auto_drop => FALSE,
enabled => TRUE);
END;
BEGIN
sys.dbms_scheduler.create_job(
job_name => '"TEST"."TEST_JOB"',
job_type => 'PLSQL_BLOCK',
job_action => 'begin
-- Insert PL/SQL code here
end;',
start_date => systimestamp at time zone 'Europe/Vienna',
job_class => '"TEST_JOB_CLASS"',
comments => 'just a test job',
auto_drop => FALSE,
enabled => TRUE);
END;