< Blog

SQL Agent Service is Not Running

By Garth Jones

I was testing out a new SQL Server Reporting Services (SSRS) report for a client and everything was working great. Before finishing the project, I needed to set-up their email report subscription. Once I clicked OK to apply the subscription, I received this error:

The SQL Agent service is not running. This operation requires the SQL Agent service. (rsSchedulerNotResponding).

SQL Agent-Error

How did I enable the SQL Agent service?

Following SQL Server best practices, I used the SQL Server Configuration Manager utility. In this case the service was set to start-up manually, so I needed to change the start mode to automatic.

There are no tricks to this, just right-click on the service name, select Properties, and then select the Service tab. After changing the Start Mode to Automatic, I clicked Apply.

Once completed, I started the service and re-did the subscription.

SQL Agent-StartMode