Oracledbms_job Oracle10g dbms_scheduler Oracle Enterprise Manager

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

JOB WHAT                                              NEXT_DATE            INTERVAL
---- ------------------------------------------------- -------------------- ----------
99 my_job_proc('DBMS_JOB.ISUBMIT Example.');         22-JUN-2004 10:11:20 SYSDATE + 1/24 /* 1 Hour */
   3 my_job_proc('DBMS_JOB.SUBMIT Example.');          22-JUN-2004 10:11:20 SYSDATE + 1/24 /* 1 Hour */

2 rows selected.

Job information is also available from the Oracle Enterprise Manager (OEM) (Network - Databases -Your-Instance - Distributed - Advanced Replication - Administration - DBMS Job Tab). Figure 2.1 shows the typical information displayed on this screen.

Figure 2.1 – OEM: DBMS Jobs

Once a job is scheduled, a change to some of its attributes may be desired. This can be achieved using the what, next_date, instance, interval and change procedures whose call specifications are displayed below.

PROCEDURE what (
job IN BINARY_INTEGER,
what IN VARCHAR2)

PROCEDURE next_date (
job IN BINARY_INTEGER,
next_date IN DATE)

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