CHANGE procedure - Modify job attributes

Syntax

>>-DBMS_JOB.CHANGE--(--job--,--what----------------------------->

>--,--next_date--,--interval--)--------------------------------><

Parameters

job

An input argument of type DECIMAL(20) that specifies the identifier of the job with the attributes to modify.

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.

what

An input argument of type VARCHAR(1024) that specifies the executable SQL statement. Set this argument to NULL if the existing value is to remain unchanged.

next_date

An input argument of type TIMESTAMP(0) that specifies the next date and time when the job is to run. Set this argument to NULL if the existing value is to remain unchanged.

interval

An input argument of type VARCHAR(1024) that specifies the date function that, when evaluated, provides the next date and time the job is to run. Set this argument to NULL if the existing value is to remain unchanged.

Authorization

EXECUTE privilege on the DBMS_JOB module.

Examples

    CALL DBMS_JOB.CHANGE(104,NULL,TO_DATE('13-DEC-09','DD-MON-YY'),NULL);