Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Jobs Job Classes create_job

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Jobs

BEGIN
DBMS_SCHEDULER.drop_job (
   job_name => 'test_full_job_definition, test_prog_sched_job_definition,
                test_prog_job_definition, test_sched_job_definition,
                argument_job_definition',
   force    => TRUE);
END;
/

The output from the jobs_10g.sql script shows that the jobs have been removed.

SQL> @jobs_10g job_user

no rows selected

The following section will focus on job classes, which are the first of the scheduler administration objects.

Job Classes

Job classes allow the grouping of jobs with similar characteristics and resource requirements to ease administration. If the job_class parameter of the create_job procedure is undefined, the job is assigned to a job class called DEFAULT_JOB_CLASS.

Job classes are created using the create_job_class procedure listed below.

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