OzarkSunshine
asked on
SQL job step to check status of another SQL job
I am wanting to create a SQL job step that will check to see if another SQL job is currently running. If so, I want the SQL job that is checking the status to quit. Not fail, just quit until next scheduled runtime.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Aneesh, I did not ask the question you have link for. Nor does it apply to what I was wanting to do but good reference for later. Thanks!
Did you try my method?
ASKER
Yes, exactly what I was looking for. Thanks!!
https://www.experts-exchange.com/questions/28735258/Make-sure-SQL-server-agent-job-is-not-running-before-executing-the-same-job-TSQL.html?anchorAnswerId=41018426#a41018426