REMOVE v13

The REMOVE procedure deletes the specified job from the database. The job must be resubmitted using the SUBMIT procedure in order to have it executed again. Note that the stored procedure that was associated with the job is not deleted.

REMOVE(<job> BINARY_INTEGER)

Parameter

job

Identifier of the job that is to be removed from the database.

Examples

Remove a job from the database:

BEGIN
    DBMS_JOB.REMOVE(104);
END;