Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_JOB.INTERVAL

Purpose

To alter the execution interval of a job. For additional information, refer to

Syntax

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

DBMS_JOB.INTERVAL(	job		IN	BINARY_INTEGER,
			interval	IN	VARCHAR2)

Parameter Description
job The identifier that was assigned to the job when you created it.
interval The date function that calculates the next time to execute the job. INTERVAL must evaluate to a future point in time or NULL.
For more information on how to specify an execution interval, see .

Table 12 - 32. Parameters for DBMS_JOB.INTERVAL

Parameter	Description
`job`	The identifier that was assigned to the job when you created it.
`interval`	The date function that calculates the next time to execute the job. INTERVAL must evaluate to a future point in time or NULL.
	For more information on how to specify an execution interval, see .