DB2 Version 9.7 for Linux, UNIX, and Windows

REMOVE procedure - Delete the job definition from the database

The REMOVE procedure deletes the specified job from the database.

In order to have it executed again in the future, the job must be resubmitted using the SUBMIT procedure.

Note: The stored procedure associated with the job is not deleted when the job is removed.

Syntax


>>-DBMS_JOB.REMOVE--(--job--)----------------------------------><

Parameters

job

An input argument of type DECIMAL(20) that specifies the identifier of the job to be removed from the database.

Note: The expected value for job identifier is not the value of TASKID in the SYSTOOLS.ADMIN_TASK_LIST view. For example, you have the following job list:

NAME                    TASKID                                          
---------------         ------                                          
DBMS_JOB_TASK_2              3                                                
DBMS_JOB_TASK_3              4

If you want to remove DBMS_JOB_TASK_2, you must pass 2 as the job identifier.

Authorization

EXECUTE privilege on the DBMS_JOB module.

Examples

Example 1: Remove a job from the database:

    CALL DBMS_JOB.REMOVE(104);