INTERVAL v13

The INTERVAL procedure sets the frequency of how often a job is to be run.

INTERVAL(<job> BINARY_INTEGER, <interval> VARCHAR2)

Parameters

job

Identifier of the job to modify.

interval

Date function that when evaluated, provides the next date/time the job is to be run. If interval is NULL and the job is complete, the job is removed from the queue.

Examples

Change the job to run once a week:

BEGIN
    DBMS_JOB.INTERVAL(104,'SYSDATE + 7');
END;