SQL Agent Jobs
Posted on 2014-11-28
I had question regarding resuming SQL Agent Jobs.
The problem that I'm facing is because of these jobs.
Actually every Saturday and Sunday, the servers in our environment are rebooted because
of patching or some other activity. Because of these the agent jobs that are scheduled on these servers
are stopped. Jobs which are usually getting affected because of these are full and differential backups.
My question is, Is there any possible way by which I can resume these jobs which are interrupted because of
server restart? Meaning as soon as the server is restarted and the SQL services are online, I want that the point at which the jobs stopped should resume again and execute until unless there is any failure or some other problem.
Kindly look into this issue and please give your comments.
Thanks in advance.