Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_JOB.CHANGE

Purpose

To alter any of the user-definable parameters associated with a job that has been submitted to the job queue. For additional information, refer to

Attention: When you change a job's definition using the WHAT parameter in the procedure CHANGE, Oracle records your current environment. This becomes the new environment for the job.

Syntax

The syntax for the procedure DBMS_JOB.CHANGE is shown below. Table 12 - 31 describes the procedure's parameters.

DBMS_JOB.CHANGE(	job		IN	BINARY_INTEGER,
			what		IN	VARCHAR2,
			next_date	IN	DATE,
			interval	IN	VARCHAR2)

Parameter Description
job The identifier that was assigned to the job when you created it.
what The PL/SQL code you want to have executed. Specify NULL to leave the current value unchanged.
For more information about defining a job, see "Job Definitions" .
next_date The next date when the job will be run. Specify NULL to leave the current value unchanged.
interval The date function that calculates the next time to execute the job. INTERVAL must evaluate to a future point in time or NULL. Specify NULL to leave the current value unchanged.
For more information on how to specify an execution interval, see .

Table 12 - 31. Parameters for DBMS_JOB.CHANGE

Parameter	Description
`job`	The identifier that was assigned to the job when you created it.
`what`	The PL/SQL code you want to have executed. Specify NULL to leave the current value unchanged.
	For more information about defining a job, see "Job Definitions" .
`next_date`	The next date when the job will be run. Specify NULL to leave the current value unchanged.
`interval`	The date function that calculates the next time to execute the job. INTERVAL must evaluate to a future point in time or NULL. Specify NULL to leave the current value unchanged.
	For more information on how to specify an execution interval, see .