September 16, 2011 at 11:13 am
The computer configuration has been changed. We need to reboot the computer. My concern is those sql jobs running on the computer. I'm thinking of disabling the sql server Agent before the reboot. My question is will the disabling the agent terminate the sql jobs instantly? I don't want that to happen. I'd like them to finish their job and then stop running until I re-enable the agent. What would be best practice?
September 16, 2011 at 11:32 am
It shouldn't be an issue to just reboot.
If it makes you feel better, just stop the engine service. Doing so should cleanly end any processes that are running and perform rollbacks/rollforwards as necessary. Once the service is stopped you can reboot the server and not worry about running processes.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply