| |
 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Job Classes
PROCEDURE create_job_class(
job_class_name IN VARCHAR2,
resource_consumer_group IN VARCHAR2
DEFAULT NULL,
service IN VARCHAR2
DEFAULT NULL,
logging_level IN PLS_INTEGER
DEFAULT
DBMS_SCHEDULER.LOGGING_RUNS,
log_history IN PLS_INTEGER
DEFAULT NULL,
comments IN VARCHAR2
DEFAULT NULL)
The parameters associated with this procedure
and their usage are as follows.
-
job_class_name - A name
that uniquely identifies the job class.
-
resource_consumer_group -
The resource consumer group associated with the job class.
-
service - The service database
object the job belongs to, not the tnsnames.ora service.
-
logging_level - The amount
of logging that should be done for this job, specified by the
constants logging_off, logging_runs, and logging_full.
-
log_history - The number of
days the logging information is kept before purging.
-
comments - Free text
allowing the user to record additional information.
Suffice it to say that it must be decided with
which resource consumer group the job class should be associated.
Information about resource consumer groups can be displayed using
the dba_rsrc_consumer_groups view.
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
