BROKEN v16

The BROKEN procedure sets the state of a job to either broken or not broken. You can execute a broken job only by using the RUN procedure.

BROKEN(<job> BINARY_INTEGER, <broken> BOOLEAN [, <next_date> DATE ])

Parameters

job

Identifier of the job to set as broken or not broken.

broken

If set to TRUE, the job’s state is set to broken. If set to FALSE, the job’s state is set to not broken. You can run broken jobs only by using the RUN procedure.

next_date

Date/time when the job is to be run. The default is SYSDATE.

Examples

Set the state of a job with job identifier 104 to broken:

BEGIN
    DBMS_JOB.BROKEN(104,true);
END;

Change the state back to not broken:

BEGIN
    DBMS_JOB.BROKEN(104,false);
END;

• On this page
• Parameters
• Examples