I need to execute a sproc in a SQL job based upon the status of another job
and have to do it this way as opposed to a new job step in one job itself
So in short I need to kinda evaluate the sp_help_job for a particular job id
or name and look at the current_execution_status and if its <> 1 then go
ahead and run the sproc . So can someone help me with the query that has the
pseudo code like this
If current_execution_status of job_id/job_name <> 1
else 'print cannot run sproc ...