Some time if we start the SQL server Agent service but sql server agent is not started so that time we can use the sp_configure option to start the agent.
- EXEC SP_CONFIGURE 'Agent XPs'
After execute this if you got the error then execute the below command
- EXEC SP_CONFIGURE 'show advanced options',1
- GO
- RECONFIGURE
- GO
- EXEC SP_CONFIGURE 'show advanced options'
And then run the command again:
- EXEC SP_CONFIGURE 'Agent XPs',1
- GO
- RECONFIGURE