Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_JOB, 8 of 12
This procedure changes how often a job runs.
DBMS_JOB.INTERVAL ( job IN BINARY_INTEGER, interval IN VARCHAR2);
Parameter | Description |
---|---|
job |
Number of the job being run. |
interval |
Date function, evaluated immediately before the job starts running. |
If the job completes successfully, then this new date is placed in next_date
. interval
is evaluated by plugging it into the statement select interval
into next_date
from dual;
The interval
parameter must evaluate to a time in the future. Legal intervals include:
|
Run once a week. |
|
Run once every Tuesday. |
|
Run only once. |
If interval
evaluates to NULL
and if a job completes successfully, then the job is automatically deleted from the queue.
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|