Suspend SQL Job

Question

Hi Expert,

is there function to suspend Running SQL job?

in case SQL job1 at 2 AM still running then next other SQL Job2 will run at 2.30 AM but SQL job1 must be suspended until SQL Job2 task completed...then SQL Job1 continue run from the checkpoint it's suspended...

how do I implement this scenario?

very great appreciation & thanks for all advice

warm regards,

Urbel

Answer 1

You would have to implement that on your own by adding checks in the code. But if the first job is the middle of a long-running operation that takes 20 minutes, it will keep running. Unless you have some monitoring job that brutally kills it.

So in short, this is nowhere close to trivial, and you probably need to rethink the overall approach here.