Home > SQL Developer Dialog Boxes ... > Create/Edit Job Class
This interface is used for creating a new Oracle Scheduler job class or editing an existing job class. For more information about job scheduling, see Scheduling Jobs Using SQL Developer.
(To create a job class, SQL Developer internally uses the DBMS_SCHEDULER.CREATE_JOB_CLASS procedure, which is documented in Oracle Database PL/SQL Packages and Types Reference.)
Name: Name of the job class. If you specify a schema, it must be SYS. For an existing job class, this field is read-only; to change the name, you must drop the job class and create a new job class with the desired name.
Description: Optional text string that can be used to describe the job class.
Logging Level: Specifies how much information is written to the job log: RUNS (detailed information for all runs of each job in this class), FULL (RUNS plus all operations performed on all jobs in this class), or OFF (no logging).
Log Retention Period (days): Number of days that job log entries for jobs in this class are retained. The range of valid values is 0 through 999. If set to 0, no history is kept. If NULL (the default), retention days are set by the log_history
Scheduler attribute (set with SET_SCHEDULER_ATTRIBUTE).
Service Name: The database service that the jobs in this class will have affinity to. If no service is specified, the job class will belong to the default service, which means it will have no service affinity and any one of the database instances within the cluster might run the job.
Resource Consumer Group: Resource consumer group this class is associated with. If no resource consumer group is specified, the job class is associated with the default resource consumer group.
Related Topics