Auto-Restart SQL Server Agent

One of the things you can do with SQL Server Agent is to automatically restart itself, or even SQL Server, in the event that the service unexpectedly stops. Just right-click on the SQL Agent service inside of SQL Server Management Server (SSMS):

If the SQL Agent service should stop unexpectedly it will now attempt to restart itself automatically. This is the preferred setting if you are relying on scheduled jobs you are expecting to run correctly. You can get more information here.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s