Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Job Classes OEM 10g DB Control Create Job Class dba_scheduler_job

Phone
800-766-1884

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Job Classes

Figure 2.11 shows the Create Job Class screen in the OEM 10g DB Control.

Figure 2.11 – OEM 10g DB Control: Create Job Class

Information about job classes can be displayed using the dba_scheduler_job_classes view. The following script uses this view:

job_classes.sql

-- *************************************************
-- Copyright © 2005 by Rampant TechPress
-- This script is free for non-commercial purposes
-- with no warranties. Use at your own risk.
--
-- To license this script for a commercial purpose,
-- contact rtp AT rampant.cc
-- *************************************************

select
   job_class_name,
   resource_consumer_group
from
   dba_scheduler_job_classes
;

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