SCCM | SQL Agent service is not running

Overview

Below error appears when creating a report subscription. ‘The SQL Agent service is  not running’.

Issue

Unable to create report subscription.

Resolution

1. RDP onto the SQL server hosting the SCCM database
2. Open SQL Server Configuration Manager
3. Select ‘SQL Server Services’ in the left hand pane. On the right hand pane right-click ‘SQL Server Agent (MSSQLSERVER)’ > Properties
   
4. Change the ‘Start Mode’ from Manual to Automatic
   
5. Apply the settings and check if the service is already running. If not start it
   
6. Try again and it will create successfully.