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

Syntax

>>-DBMS_JOB.NEXT_DATE--(--job--,--next_date--)-----------------><

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

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