Chapter 2 -
Configuring Oracle Job Scheduling
||Oracle Tips by Burleson
job_class_name IN VARCHAR2,
resource_consumer_group IN VARCHAR2
service IN VARCHAR2
logging_level IN PLS_INTEGER
log_history IN PLS_INTEGER
comments IN VARCHAR2
The parameters associated with this procedure
and their usage are as follows.
job_class_name - A name
that uniquely identifies the job class.
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:
definitive Oracle Script collection for every Oracle professional DBA