title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | |||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Start, stop, or pause the SQL Server Agent service |
Start, stop, or pause the SQL Server Agent service. |
markingmyname |
maghan |
randolphwest |
07/26/2024 |
sql |
ssms |
how-to |
|
=azuresqldb-mi-current || >=sql-server-2016 |
[!INCLUDE SQL Server SQL MI]
Important
On Azure SQL Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Managed Instance T-SQL differences from SQL Server for details.
This article describes how to start, stop, or restart the SQL Server Agent Service in [!INCLUDE ssnoversion] by using SQL Server Management Studio.
You can configure the [!INCLUDE ssNoVersion] Agent service to start automatically when the operating system starts, or you can start it manually when you need to complete jobs. You can stop or pause the [!INCLUDE ssNoVersion] Agent service to suspend jobs, operator notifications, and alerts.
[!INCLUDE msCoName] [!INCLUDE ssNoVersion] Agent must be running as a service in order to automate administrative tasks. For more information, see Configure SQL Server Agent.
Object Explorer only displays the [!INCLUDE ssNoVersion] Agent node if you have permission to use it.
To perform its functions, [!INCLUDE ssNoVersion] Agent must be configured to use the credentials of an account that is a member of the sysadmin fixed server role in [!INCLUDE ssNoVersion]. 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 [!INCLUDE ssNoVersion] Agent service account, see Select an account for the SQL Server Agent service and Configure Windows service accounts and permissions.
-
In Object Explorer, select the plus sign to expand the server where you want to manage SQL Server Agent Service.
-
Right-click SQL Server Agent, and then select either Start, Stop, or Restart.
-
In the User Account Control dialog box, select Yes.
-
When prompted if you want to perform the action, select Yes.