I have a SQL Server job which has to check if the mainframe DB2 job is complete (for the data) and then run the SSIS packages. I plan to add step 1 to check if the job is complete. I cannot add the job name directly in stored procedure which is one of the ways we write two SQL jobs dependency. Is there any other way?