February 5, 2013 at 6:27 am
Hello --
I made several changes to the Database Mail configuration, and in order for them to go into effect, I will need to restart the SQL Agent. The standard practice that I have used is to wait until after hours before restarting the agent. This is done to ensure that access to the database and its front-end application does not get interrupted during the workday.
I was curious to know if restarting the agent would indeed interrupt access to the database and application, or would such an action not be have that effect?
Thanks.
February 5, 2013 at 7:08 am
Just restarting Agent will not affect the Database Engine in and of itself. Restarting Agent can have some side-effects though that you'll want to check on beforehand. Check for jobs that have a schedule to 'start when the sql server agent starts' and make sure you want those jobs to run in this scenario. Also wait for running jobs to complete before restarting and account for any missed executions for upcoming job schedules should the service restart takes more than a minute or two so you can run those jobs manually when the service comes back.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 6, 2013 at 1:28 pm
No. SQL agent restart will in no way effect the SQL Database Engine access.
SQL Agent is used as a job scheduler. so only your jobs will get affected if there are any running around the restart time(as noted in the earlier post correctly).
Regards
Satyen.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply