| title | Autostart SQL Server Agent | ||
|---|---|---|---|
| ms.prod | sql | ||
| ms.prod_service | sql-tools | ||
| ms.technology | ssms | ||
| ms.topic | conceptual | ||
| helpviewer_keywords |
|
||
| ms.assetid | 2ea332da-0ede-4d2b-b122-c4c10eaca191 | ||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.manager | jroth | ||
| ms.reviewer | |||
| ms.custom | seo-lt-2019 | ||
| ms.date | 01/19/2017 | ||
| monikerRange | = azuresqldb-mi-current || >= sql-server-2016 || = sqlallproducts-allversions |
[!INCLUDEappliesto-ss-asdbmi-xxxx-xxx-md]
Important
On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.
This topic describes how to configure [!INCLUDEmsCoName] [!INCLUDEssNoVersion] Agent to automatically restart if it should stop unexpectedly in [!INCLUDEssCurrent].
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 Setting Up Windows Service Accounts.
-
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.