 |
|
Oracle Tips by Burleson |
Chapter 2 -
Configuring Oracle Job Scheduling
Overview and
Examples of dbms_job Functions
The output generated by the user_jobs.sql shows that the
changes have been applied.
SQL> @jobs job_user
JOB
WHAT NEXT_DATE
INTERVAL
---
----------------------------------------- --------------------
------------------------------
99
my_job_proc('DBMS_JOB.ISUBMIT Example.'); 22-JUN-2004 11:36:23
SYSDATE + 1/24 /* 1 Hour */
3
my_job_proc('DBMS_JOB.SUBMIT Example.'); 22-JUN-2004 11:11:17
SYSDATE + 1/24 /* 1 Hour */
2 rows selected.
The broken procedure allows the broken flag
associated with the job to be altered, as shown below.
PROCEDURE
broken (
job
IN BINARY_INTEGER,
broken
IN BOOLEAN,
next_date
IN DATE DEFAULT SYSDATE)
Jobs that are set as broken are not run, so
this is a convenient way to temporarily stop them. The following
example shows how the broken procedure is used:
|
Download your Oracle scripts now:
www.oracle-script.com
The
definitive Oracle Script collection for every Oracle professional DBA
|
|
