DB2 Examples:
1. DB2 example of a call from a Stored Procedure:
Add the following to the declaration section of the stored procedure:
DECLARE v_result INTEGER;
DECLARE v_return_code VARCHAR(1);
DECLARE v_return_msg VARCHAR(256);
Then add the call to Ws_Job_Release:
CALL [METABASE].Ws_Job_Restart(p_sequence,p_job_name,p_task_name,p_job_id,p_task_id
,'Daily Run',v_return_code,v_return_msg,v_result);
Perhaps add a check of the result:
IF ( v_result <> 1 ) THEN
SET p_status = v_result;
SET p_return_msg = 'Failed to restart Daily Run. Return Code was '||v_return_code;
SET p_return_msg = p_return_msg || '. ' || v_return_msg;
RETURN 0;
END IF;
2. DB2 example of a call from the DB2 Command Line Processor (db2.exe):
Enter the following after connecting (the metadata is in a schema called QAD Data Warehouse Designer):
call Data Warehouse Designer.Ws_Job_Restart(0,'Restart Job','Restart',0,0,'Daily Run',?,?,?)
The following out is typical:
Value of output parameters
--------------------------
Parameter Name : P_RETURN_CODE
Parameter Value : S
Parameter Name : P_RETURN_MSG
Parameter Value : Job Daily Run restart.
Parameter Name : P_RESULT
Parameter Value : 1
Return Status = 0
3. DB2 example of a call from QAD SQL Admin (the metadata is in a schema called QAD Data Warehouse Designer):
{call Data Warehouse Designer.Ws_Job_Restart(1, 'Restart Daily Job','Restart',0,0,'Daily Run',?,?,?)};
Ws_Job_Schedule
This procedure allows the automated rescheduling of a holding or waiting job. The intended use of this function is to allow the scheduling of a job from within another job. Only jobs that are in a Hold state (i.e. Once and Hold jobs), or in a Waiting state can be rescheduled.