Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_JOB.BROKEN

Purpose

To mark a job as broken or not broken. You can mark only jobs you own as broken. For additional information, refer to

Syntax

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

DBMS_JOB.BROKEN(	job		IN	BINARY_INTEGER,
			broken		IN	BOOLEAN,
			next_date	IN	DATE DEFAULT SYSDATE)

Parameter Description
job The identifier that was assigned to the job when you created it.
broken Indicates the state of the job.
TRUE indicates that the job is broken and should not be executed. FALSE indicates that the job is not broken and should be executed at its normal execution interval, starting with NEXT_DATE.
next_date The date at which the job will be run next. The default value is SYSDATE.

Table 12 - 30. Parameters for DBMS_JOB.BROKEN

Parameter	Description
`job`	The identifier that was assigned to the job when you created it.
`broken`	Indicates the state of the job.
	TRUE indicates that the job is broken and should not be executed. FALSE indicates that the job is not broken and should be executed at its normal execution interval, starting with NEXT_DATE.
`next_date`	The date at which the job will be run next. The default value is SYSDATE.