DB2 Version 9.7 for Linux, UNIX, and Windows

RUN procedure - Force a broken job to run

The RUN procedure forces a job to run, even if it has a broken state.

Syntax


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

Parameters

job

An input argument of type DECIMAL(20) that specifies the identifier of the job to run.

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 run DBMS_JOB_TASK_2, you must pass 2 as the job identifier.

Authorization

EXECUTE privilege on the DBMS_JOB module.

Examples

Example 1: Force a job to run.

    CALL DBMS_JOB.RUN(104);