Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms

Phone
252-431-0050

Privacy Policy

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Job Classes

The output from the job_classes.sql script is displayed below.

SQL> @job_classes

JOB_CLASS_NAME                 RESOURCE_CONSUMER_GROUP
------------------------------ ------------------------------
DEFAULT_JOB_CLASS
AUTO_TASKS_JOB_CLASS           AUTO_TASK_CONSUMER_GROUP
TEST_JOB_CLASS                 DEFAULT_CONSUMER_GROUP

3 rows selected.

Figure 2.12 shows the Scheduler Job Classes screen in the OEM 10g DB Control.

Figure 2.12 – OEM 10g DB Control: Scheduler Job Classes

Jobs can be assigned to a job class during creation. It is also possible to assign a job to an alternative job class after creation using one of the set_attribute procedure overloads.

BEGIN
-- Job defined and assigned to a job class.
DBMS_SCHEDULER.create_job (
    job_name      => 'test_prog_sched_class_job_def',
    program_name => 'test_plsql_block_prog',
    schedule_name => 'test_hourly_schedule',
    job_class     => 'test_job_class',
    enabled       => TRUE,
    comments      => 'Job defined and assigned to a job class ')
END;
/

The above text is an excerpt from:

Oracle Job Scheduling
Creating Robust Task Management with dbms_job and Oracle10g dbms_scheduler

ISBN 0-9744486-6-4

by Dr. Timothy S. Hall

http://www.rampant-books.com/book_2005_1_scheduling.htm

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA