INTERVAL Procedure

This procedure changes how often a job runs.

Syntax

DBMS_JOB.INTERVAL ( 
   job       IN  BINARY_INTEGER,
   interval  IN  VARCHAR2);

Parameters

Table 19-8 INTERVAL Procedure Parameters

Parameter	Description
job	Number of the job being run.
interval	Date function, evaluated immediately before the job starts running.

Usage Notes

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:

'sysdate + 7'	Run once a week.
'next_day(sysdate,''TUESDAY'')'	Run once every Tuesday.
'null'	Run only once.

If interval evaluates to NULL and if a job completes successfully, then the job is automatically deleted from the queue.