Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_JOB.WHAT

Purpose

To alter the definition of a job in the job queue. For additional information, refer to

Attention: When you execute procedure WHAT, Oracle records your current environment. This becomes the new environment for the job.

Syntax

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

DBMS_JOB.WHAT(	job		IN	BINARY_INTEGER,
			what		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. In the job definition, use two single quotation marks around strings. Always include a semicolon at the end of the job definition.

Table 12 - 37. Parameters for DBMS_JOB.WHAT

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. In the job definition, use two single quotation marks around strings. Always include a semicolon at the end of the job definition.