INTERVAL is a stored procedure that modifies the interval for a job to run.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_JOB.INTERVAL (
job IN BINARY_INTEGER,
interval IN VARCHAR2);
Parameters
| Parameter | Description |
|---|---|
| job | The unique ID of the job to be modified. To find this ID, query the JOB column of the USER_JOBS or DBA_JOBS view. |
| interval | The time interval for the job. |
Considerations
If the stored procedure is executed successfully, the
intervalfield of the job will be updated. The next run time of the job will be calculated by the SQL statementSELECT INTERVAL INTO NEXT_DATE FROM DUAL.The interval parameter must be a future time. The valid intervals are as follows:
Interval Description 'sysdate + 7' Runs once a week. 'next_day(sysdate,''TUESDAY'')' Runs once every Tuesday. 'null' Runs only once. If
intervalisNULLand the job is successfully completed, the job will be automatically removed from the queue.Before submission, the job cannot be processed by the background job queue.