| title | Autostart SQL Server Agent (SQL Server Management Studio) | Microsoft Docs | ||
|---|---|---|---|
| ms.custom | |||
| ms.date | 03/06/2017 | ||
| ms.prod | sql-server-2014 | ||
| ms.reviewer | |||
| ms.technology | ssms | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 2ea332da-0ede-4d2b-b122-c4c10eaca191 | ||
| author | stevestein | ||
| ms.author | sstein | ||
| manager | craigg |
This topic describes how to configure [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent to automatically restart if it should stop unexpectedly in [!INCLUDEssCurrent].
In This Topic
-
Before you begin:
-
To configure SQL Server Agent to automatically restart, using SQL Server Management Studio
Object Explorer only displays the [!INCLUDEssNoVersion] Agent node if you have permission to use it.
To perform its functions, [!INCLUDEssNoVersion] Agent must be configured to use the credentials of an account that is a member of the sysadmin fixed server role in [!INCLUDEssNoVersion]. The account must have the following Windows permissions:
-
Log on as a service (SeServiceLogonRight)
-
Replace a process-level token (SeAssignPrimaryTokenPrivilege)
-
Bypass traverse checking (SeChangeNotifyPrivilege)
-
Adjust memory quotas for a process (SeIncreaseQuotaPrivilege)
For more information about the Windows permissions required for the [!INCLUDEssNoVersion] Agent service account, see Select an Account for the SQL Server Agent Service and Configure Windows Service Accounts and Permissions.
-
In Object Explorer, click the plus sign to expand the server where you want to configure SQL Server Agent to automatically restart.
-
Right-click SQL Server Agent, and then click Properties.
-
On the General page, check Auto restart SQL Server Agent if it stops unexpectedly.