Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_JOB.SUBMIT

Purpose

To submit a new job to the job queue. For additional information, refer to

Syntax

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

DBMS_JOB.SUBMIT(	job		OUT	BINARY_INTEGER,
			what		IN	VARCHAR2,
			next_date	IN	DATE DEFAULT SYSDATE,
			interval	IN	VARCHAR2 DEFAULT 'null',
			no_parse	IN	BOOLEAN DEFAULT FALSE)

Parameter Description
job(out parameter) The identifier assigned to the job you created. You must use the job number whenever you want to alter or remove the job.
For more information about job numbers, see "Job Numbers" .
what is 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.
For more information about defining a job, see "Job Definitions" .
next_date is the next date when the job will be run. The default value is SYSDATE.
interval is the date function that calculates the next time to execute the job. The default value is NULL. INTERVAL must evaluate to a future point in time or NULL.
For more information on how to specify an execution interval, see .
no_parse is a flag. The default value is FALSE.
If NO_PARSE is set to FALSE (the default), Oracle parses the procedure associated with the job. If NO_PARSE is set to TRUE, Oracle parses the procedure associated with the job the first time that the job is executed. If, for example, you want to submit a job before you have created the tables associated with the job, set NO_PARSE to TRUE.

Table 12 - 36. Parameters for DBMS_JOB.SUBMIT

Parameter	Description
`job`(out parameter)	The identifier assigned to the job you created. You must use the job number whenever you want to alter or remove the job.
	For more information about job numbers, see "Job Numbers" .
`what`	is 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.
	For more information about defining a job, see "Job Definitions" .
`next_date`	is the next date when the job will be run. The default value is SYSDATE.
`interval`	is the date function that calculates the next time to execute the job. The default value is NULL. INTERVAL must evaluate to a future point in time or NULL.
	For more information on how to specify an execution interval, see .
`no_parse`	is a flag. The default value is FALSE.
	If NO_PARSE is set to FALSE (the default), Oracle parses the procedure associated with the job. If NO_PARSE is set to TRUE, Oracle parses the procedure associated with the job the first time that the job is executed. If, for example, you want to submit a job before you have created the tables associated with the job, set NO_PARSE to TRUE.