So I have 2 separate Agent Jobs on SQL Server scheduled to run sequentially every 2 hours, which means that if Job A starts right now, Job B will start one hour from now and then Job A will start one hour after that, and so on.
98% of the time, the Jobs complete within 60 min, but sometimes if one Job takes over 60 min to complete, it will overlap with the other Job and will make that Job to fail. I could make the Job interval bigger so that each Job would get more time to complete, but I don't want to do that.
So my question is: Is there any way to prevent these two jobs stop from colliding? I mean, if Job A takes over 60 min to complete, can I make Job B delay and only start after Job A completed?
Any feedback is greatly appreciated. Thank you!