Oracledbms_job Oracle10g dbms_scheduler what next

BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Oracle Tips by Burleson

Oracle Job Scheduling

Chapter 2 - Configuring Oracle Job Scheduling

Overview and Examples of dbms_job Functions

PROCEDURE instance (
job       IN BINARY_INTEGER,
instance IN BINARY_INTEGER,
force     IN BOOLEAN DEFAULT FALSE)

PROCEDURE interval (
job       IN BINARY_INTEGER,
interval IN VARCHAR2)

PROCEDURE change (
job       IN BINARY_INTEGER,
what      IN VARCHAR2,
next_date IN DATE,
interval IN VARCHAR2,
instance IN BINARY_INTEGER DEFAULT NULL,
force     IN BOOLEAN DEFAULT FALSE)

The what, next_date, instance and interval procedures allows the individual attributes of the same name to be altered, while the change procedure allows all of them to be altered in one go, effectively replacing the existing job. The examples below show how the procedures can be used:

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

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books