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).
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.
