The NEXT_DATE stored procedure changes the next running date of a job.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Syntax
DBMS_JOB.NEXT_DATE (
job IN BINARY_INTEGER,
next_date IN DATE);
Parameters
| Parameter | Description |
|---|---|
| job | The unique ID of the job to be modified. You can query this ID from the JOB column of the USER_JOBS or DBA_JOBS view. |
| next_date | The next date to run the job. |
Usage notes
Before a job is submitted, it cannot be handled by the job queue in the background.