Ws_Job_Dependency

Synopsis
Adds or removes a child-to-parent dependency between two jobs to control the child job.
Description
Adds or removes a child-to-parent dependency between two jobs to control the child job. The dependent child job can be defined to fail (if necessary) when the parent job does not complete successfully in the required timeframe. The acceptable timeframe can be defined in terms of the maximum minutes in the past, to look back and the maximum minutes in the future to wait for successful completion of the parent job.
Input

Input	Description
Common Input	Includes all 5 inputs of the Callable Routines Common Input.
Action	Either 'ADD' or 'DELETE' the job dependency.
Parent Job Name	The name of Parent Job that the Child Job will depend on.
Child Job Name	The name of the Child Job that will be dependent on the Parent Job.
Parent Success Required	Indicates whether or not the Child Job will fail when the Parent Job does not complete successfully in the required time frame.
Maximum Look Back Minutes	The Maximum minutes in the past to look back for successful completion of the Parent Job.
Maximum Wait Minutes	The Maximum minutes in the future to wait for successful completion of the Parent Job.

Output

Description

Return Code

Output Return Code:

S Success.
W Warning. Dependency already exists ('ADD' action) or does not exist ('DELETE' action).
E Error.
F Fatal/Unexpected Error.

Return Message

Output message indicating the action applied or the reason for no action.

Result Number

Output Result Number:

1 Success.
-1 Warning. Dependency already exists ('ADD' action) or does not exist ('DELETE' action).
-2 Error. e.g. Due to invalid job name or job not running.
-3 Fatal/Unexpected Error.

SQL Server

SQL Server Parameters: Ws_Job_Dependency
Callable Routine Type: PROCEDURE.

Parameter Name	Datatype	Mode
@p_sequence	INTEGER	IN
@p_job_name	VARCHAR(64)	IN
@p_task_name	VARCHAR(64)	IN
@p_job_id	INTEGER	IN
@p_task_id	INTEGER	IN
@p_action	VARCHAR(64)	IN
@p_parent	VARCHAR(64)	IN
@p_child	VARCHAR(64)	IN
@p_required	VARCHAR(1)	IN
@p_look_back	INTEGER	IN
@p_max_wait	INTEGER	IN
@p_return_code	VARCHAR(1)	OUT
@p_return_msg	VARCHAR(256)	OUT
@p_result	INTEGER	OUT

SQL Server Examples: Ws_Job_Dependency

– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure.
DECLARE @p_sequence integer
DECLARE @p_job_name varchar(256)
DECLARE @p_task_name varchar(256)
DECLARE @p_job_id integer
DECLARE @p_task_id integer
DECLARE @p_return_msg varchar(256)
DECLARE @p_status integer
DECLARE @v_result_num integer
DECLARE @v_return_code varchar(1)
DECLARE @v_return_msg varchar(256)
EXEC Ws_Job_Dependency
@p_sequence, @p_job_name, @p_task_name, @p_job_id, @p_task_id
, 'ADD', 'Daily Run', 'Daily Run Part2', 'Y', 60, 60
, @v_return_code OUTPUT
, @v_return_msg OUTPUT
, @v_result_num OUTPUT

Teradata

Teradata Parameters: Ws_Job_Dependency
Callable Routine Type: PROCEDURE.

Parameter Name	Datatype	Mode
p_sequence	INTEGER	IN
p_job_name	VARCHAR(64)	IN
p_task_name	VARCHAR(64)	IN
p_job_id	INTEGER	IN
p_task_id	INTEGER	IN
p_action	VARCHAR(10)	IN
p_parent	VARCHAR(64)	IN
p_child	VARCHAR(64)	IN
p_required	VARCHAR(1)	IN
p_look_back	INTEGER	IN
p_max_wait	INTEGER	IN
p_return_code	VARCHAR(1)	OUT
p_return_msg	VARCHAR(256)	OUT
p_result	INTEGER	OUT

Teradata Examples: Ws_Job_Dependency

– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure.
DECLARE p_sequence integer;
DECLARE p_job_name varchar(256);
DECLARE p_task_name varchar(256);
DECLARE p_job_id integer;
DECLARE p_task_id integer;
DECLARE p_return_msg varchar(256);
DECLARE p_status integer;
DECLARE v_result_num integer;
DECLARE v_return_code varchar(1);
DECLARE v_return_msg varchar(256);
CALL [METABASE].Ws_Job_Dependency
( p_sequence, p_job_name, p_task_name, p_job_id, p_task_id
, 'ADD', 'Daily Run', 'Daily Run Part2', 'Y', 60, 60
, v_return_code
, v_return_msg
, v_result_num
);

Oracle

Oracle Parameters: Ws_Job_Dependency
Callable Routine Type: FUNCTION.

Parameter Name	Datatype	Mode
p_sequence	NUMBER	IN
p_job_name	VARCHAR2	IN
p_task_name	VARCHAR2	IN
p_job_id	NUMBER	IN
p_task_id	NUMBER	IN
p_action	VARCHAR2	IN
p_parent	VARCHAR2	IN
p_child	VARCHAR2	IN
p_required	VARCHAR2	IN
p_look_back	NUMBER	IN
p_max_wait	NUMBER	IN
p_return_code	VARCHAR2	OUT
p_return_msg	VARCHAR2	OUT
FUNCTION Return Value	NUMBER	OUT-Function

Oracle Examples: Ws_Job_Dependency

– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure.
p_sequence number;
p_job_name varchar2(256);
p_task_name varchar2(256);
p_job_id number;
p_task_id number;
p_return_msg varchar2(256);
p_status number;
v_result_num number;
v_return_code varchar2(1);
v_return_msg varchar2(256);
v_result_num := Ws_Job_Dependency
( p_sequence, p_job_name, p_task_name, p_job_id, p_task_id
, 'ADD', 'Daily Run', 'Daily Run Part2', 'Y', 60, 60
, v_return_code
, v_return_msg
);

DB2

DB2 Parameters: Ws_Job_Dependency
Callable Routine Type: PROCEDURE.

Parameter Name	Datatype	Mode
p_sequence	INTEGER	IN
p_job_name	VARCHAR(64)	IN
p_task_name	VARCHAR(64)	IN
p_job_id	INTEGER	IN
p_task_id	INTEGER	IN
p_action	VARCHAR(10)	IN
p_parent	VARCHAR(64)	IN
p_child	VARCHAR(64)	IN
p_required	VARCHAR(1)	IN
p_look_back	INTEGER	IN
p_max_wait	INTEGER	IN
p_return_code	VARCHAR(1)	OUT
p_return_msg	VARCHAR(256)	OUT
p_result	INTEGER	OUT

DB2 Examples: Ws_Job_Dependency

– The p_ VARIABLES are normally PARAMETERS in a RED-generated Procedure.
DECLARE p_sequence integer;
DECLARE p_job_name varchar(256);
DECLARE p_task_name varchar(256);
DECLARE p_job_id integer;
DECLARE p_task_id integer;
DECLARE p_return_msg varchar(256);
DECLARE p_status integer;
DECLARE v_result_num integer;
DECLARE v_return_code varchar(1);
DECLARE v_return_msg varchar(256);
CDATA[CALL [METABASE].Ws_Job_Dependency
( p_sequence, p_job_name, p_task_name, p_job_id, p_task_id
, 'ADD', 'Daily Run', 'Daily Run Part2', 'Y', 60, 60
, v_return_code
, v_return_msg
, v_result_num
);

Content

Space Tools

SQL Server

Teradata

Oracle

DB2