Hi @SASKiwi @Reeza, Below is what I basically require and pasted the code and data also. I am actually stuck 🙂 When val=0, I am executing a set of jobs, when val = 1, then I have to check if its dependents run status if "P", if so then I have to execute the job. Dependents are in different table. Attached the data for your reference. For the Job J_RM_T_BSRM_MASTER002 in CHECK Table, val =1 , so I have to check MASTER table for the dependents(J_RM_T_BSRM_MASTER001 and J_RM_T_BSRM_MASTER003), then again compare with CHECK table to runstatus which is "P" , if "P", the I have to trigger the job J_RM_T_BSRM_MASTER002 (This part I can use X command) Please note J_RM_T_BSRM_MASTER001 and J_RM_T_BSRM_MASTER003 will be triggered as ist dependents are with val=0, so it has to be triggered automatically. This is just a small set of jobs, so I am triggering based on a table . Below is the data for reference. data WORK.CHECK; infile datalines dsd truncover; input JOBNAME:$100. RUNSTATUS:$1. val:32.; datalines4; J_RM_T_BSRM_MASTER001,,1 J_RM_T_BSRM_CHILD001,,0 J_RM_T_BSRM_CHILD002,,0 J_RM_T_BSRM_CHILD003,,0 J_RM_T_BSRM_MASTER002,,1 J_RM_T_BSRM_MASTER003,,1 J_RM_T_BSRM_CHILD004,,0 J_RM_T_BSRM_CHILD005,,0 J_RM_T_BSRM_CHILD006,,0 ;;;; data WORK.MASTER; infile datalines dsd truncover; input JOBNAME:$30. Dependentjobname:$30.; datalines4; J_RM_T_BSRM_MASTER001,J_RM_T_BSRM_CHILD001 J_RM_T_BSRM_MASTER001,J_RM_T_BSRM_CHILD002 J_RM_T_BSRM_MASTER001,J_RM_T_BSRM_CHILD003 J_RM_T_BSRM_MASTER002,J_RM_T_BSRM_MASTER001 J_RM_T_BSRM_MASTER002,J_RM_T_BSRM_MASTER003 J_RM_T_BSRM_MASTER003,J_RM_T_BSRM_CHILD004 J_RM_T_BSRM_MASTER003,J_RM_T_BSRM_CHILD005 J_RM_T_BSRM_MASTER003,J_RM_T_BSRM_CHILD006 ;;;; Thanks and Regards Sandhya S
... View more