SQLServerAgent is not currently running so it cannot be notified of this action

Question

This is for very first time that I am trying to use SQL server Agent. I get this error :

Msg 22022, Level 16, State 1, Line 0
SQLServerAgent is not currently running so it cannot be notified of this action.

I went to services to check if it was running. I tried to start it and got this immediately . The services then stopped ofcourse.:

Then I tried with SQL server configuration manager:

On trying to start the service there,

When I try to change the log on account via SQL server configuration manager:

How do I get this service started ?

Dub

Answer 1

The SQL Server Express editions does not include the SQL Server Agent component. If you want that you need to use any of the versions that includes it (Enterprise, Business Intelligence, Standard or Web).

Reference: Features Supported by the Editions of SQL Server 2014 (the same limits applies to earlier editions too).

Coom

Thank you. So, are all of these paid versions ? – Dub

@Dub I believe so, yes. If you just need the functionality of the Agent then there are some possible solutions in this answer: https://mcmap.net/q/153325/-automate-a-sql-query-to-run-every-month – Coom

Answer 2

It can happen as well that you have SQL Service Agent installed on your server with the database, but as the message says it is not running.

Go to Control Panel -> Administrative Tools -> Services and check if service SQL Service Agent is running.

Jesuit