 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Job Classes
The parameters associated with this procedure and their usage are as
follows:
-
job_class_name - A name
that specifies a single or comma separated list of job class names.
-
force - When set to TRUE, all
jobs that are assigned to the job class are disabled and have their
job class set to the default. When set to FALSE, attempting to drop
a job class that has dependant jobs will cause an error.
The following code example shows how a job
class can be removed
BEGIN
DBMS_SCHEDULER.drop_job_class (
job_class_name => 'test_job_class',
force => TRUE);
END;
/
The output of the job_classes.sql script
shows that the job class has been removed successfully.
SQL> @job_classes
JOB_CLASS_NAME
RESOURCE_CONSUMER_GROUP
------------------------------
------------------------------
DEFAULT_JOB_CLASS
AUTO_TASKS_JOB_CLASS
AUTO_TASK_CONSUMER_GROUP
2 rows selected.
Now that to the creation of job classes has been presented, the next
section will cover windows, another type of scheduler administration
object.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
