Abhinav Singh
asked on
SQL Agent Jobs
Hello Guys,
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
We tried coming up with better strategy, but that too is not working out.
If you could just tell me that there is any other way or some query using which we could find the job was stopped and make it execute again from where it stopped, then it would be helpful.
Thanks for replying