Oracle Job Scheduling Robust Task Management dbms_job Oracle10g dbms_scheduler Job Classes drop_job_class

Phone
800-766-1884

Oracle 11g Books

Oracle training

STATSPACK Viewer

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Job Classes

JOB_USER TEST_PROG_SCHED_JOB_DEFINITION TEST_JOB_CLASS TRUE
22-JUN-04 15.00.16.200000 +01:00

JOB_USER TEST_PROG_JOB_DEFINITION DEFAULT_JOB_CLASS TRUE
22-JUN-04 15.00.09.600000 +01:00
freq=hourly; byminute=0

JOB_USER TEST_SCHED_JOB_DEFINITION DEFAULT_JOB_CLASS TRUE
22-JUN-04 15.00.16.200000 +01:00

JOB_USER ARGUMENT_JOB_DEFINITION DEFAULT_JOB_CLASS TRUE
22-JUN-04 15.00.16.200000 +01:00

JOB_USER TEST_PROG_SCHED_CLASS_JOB_DEF TEST_JOB_CLASS TRUE
22-JUN-04 15.00.16.200000 +01:00

6 rows selected.

Job classes can be removed using the drop_job_class procedure listed below:

PROCEDURE drop_job_class (
job_class_name IN VARCHAR2,
force IN BOOLEAN DEFAULT FALSE)

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

Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation.
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks