NEXT_DATE procedure - Set the date and time when a job is run

The NEXT_DATE procedure sets the next date and time of when the job is to run.

Syntax

Parameters

job

An input argument of type DECIMAL(20) that specifies the identifier of the job whose next run date is to be modified.

Note: The expected value for job identifier is not the value of TASKID in the SYSTOOLS.ADMIN_TASK_LIST view. For example, you have the following job list:

NAME                    TASKID                                          
---------------         ------                                          
DBMS_JOB_TASK_2              3                                                
DBMS_JOB_TASK_3              4

If you want to modify DBMS_JOB_TASK_2, you must pass 2 as the job identifier.

next_date

An input argument of type TIMESTAMP(0) that specifies the date and time when the job is to be run next.

Authorization

EXECUTE privilege on the DBMS_JOB module.

Examples

Example 1: Change the job to run next on December 14, 2009:

    CALL DBMS_JOB.NEXT_DATE(104, TO_DATE('14-DEC-09','DD-MON-YY'));