Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Job Classes set

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Job Classes

BEGIN
-- Assign an existing job to a job class.
DBMS_SCHEDULER.set_attribute (
    name      => 'test_prog_sched_job_definition',
    attribute => 'job_class',
    value     => 'test_job_class');
END;
/

The output from the jobs_10g.sql script shows that the job classes associated with these jobs has been set correctly.

SQL> @jobs_10g job_user

OWNER JOB_NAME JOB_CLASS ENABLE
---------- ------------------------------ ---------------- ------
NEXT_RUN_DATE
-----------------------------------------------------------------
REPEAT_INTERVAL
-----------------------------------------------------------------
JOB_USER TEST_FULL_JOB_DEFINITION DEFAULT_JOB_CLASS TRUE
22-JUN-04 15.00.08.900000 +01:00
freq=hourly; byminute=0

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