Link to home
Start Free TrialLog in
Avatar of OzarkSunshine
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.
Avatar of Aneesh
Aneesh
Flag of Canada image

ASKER CERTIFIED SOLUTION
Avatar of Scott Pletcher
Scott Pletcher
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of OzarkSunshine
OzarkSunshine

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?
Yes, exactly what I was looking for.  Thanks!!