Oracle9i Supplied PL/SQL Packages and Types Reference Release 1 (9.0.1) Part Number A89852-02 |
|
DBMS_JOB, 4 of 12
This procedure changes any of the user-settable fields in a job.
DBMS_JOB.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 parameters instance
and force
are added for job queue affinity. Job queue affinity gives users the ability to indicate whether a particular instance or any instance can run a submitted job.
If the parameters what
, next_date
, or interval
are NULL
, then leave that value as it is.
EXECUTE DBMS_JOB.CHANGE(14144, null, null, 'sysdate+3');
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|