How Do I Enable SQL Server Agent Service?

The SQL Server Agent service is used by SQL Server to execute scheduled tasks. It is typically used for items such as backing up the SQL Server database or other maintenance tasks. By default, this service is not enabled when you install SQL Server. This blog post will show you how to enable this service.

Enabling SQL Server Agent service

As with any SQL service, you should NOT enable or change them to use the Services Microsoft Management Console (MMC) snap-in; instead, you should use the SQL Server Configuration Manager tool.

1. To start this process on your SQL Server, launch SQL Server Configuration Manager.

How to Enable SQL Server Agent Service-SQL Server Configuration Manager

2. Right-click the SQL Server Agent service and click Properties.

How to Enable SQL Server Agent Service-Properties

3. On the Properties Window, select an appropriate account. I will use the Local System account for my example. Then click on the Service tab.

How to Enable SQL Server Agent Service-Log On 

4. Change the Start Mode to Automatic and then click OK to close the window.

How to Enable SQL Server Agent Service-Start Mode

5. Right-click the SQL Server Agent service and click Start.

How to Enable SQL Server Agent Service-Start

6. With that last step completed, the SQL Server Agent service is ready to be used.

How to Enable SQL Server Agent Service-Running 

If you have any questions, please feel free to contact me at @GarthMJ.

Showing 4 comments
  • kyleolinger
    Reply

    Configuration Manager properly sets the usage permissions for the SQL Server service account while the services.msc applet does not. Just completed SQL 2012 Admin course and the instructor was adament about never starting and stopping SQL services via the services.msc. You should always use SQL Configuration Manager. This was also true going back to SQL 2005. So the question begs.. why were you starting anything for SQL via the Services.msc?

    • Garth Jones (Admin)
      Reply

      I’m not recommend that you use services.msc. the quote this blog it says “As with any SQL service, you should NOT enable or change them to use the Services Microsoft Management Console (MMC) snap-in; instead, you should use the SQL Server Configuration Manager tool.”

  • msykutera
    Reply

    Just tried it and it works. Thanks

pingbacks / trackbacks
  • […] Note: If you receive a message that states, “SQLServerAgent is not currently running so it cannot be notified of this action,” this means that your SQL Server Agent Service is not running. Correct this and execute the query again. For tips on how to enable the agent see my blog post, “How Do I Enable SQL Server Agent Service?” […]

Leave a Comment

Share via
Copy link
Powered by Social Snap