SQL Server Agent not appearing in Management Studio

Question

Hi Team,

I have installed SSMS EXPRESS EDITION and SQL SERVER 2019, however SQL SERVER AGENT is not showing in SSMS.
I checked sql server configuration management and there it is present in stopped state and start mode is other(Boot System, Disabled or Unknown).

Can anyone please let me know how can I enabled this.

Thanks

Answer 1

Hi @Diksha Gupta ,

> I have installed SSMS EXPRESS EDITION and SQL SERVER 2019, however SQL SERVER AGENT is not showing in SSMS.

SSMS do not have Express edition. SSMS only has version, such as SSMS 17.x version, SSMS 18.x version, etc. SQL server has Express, developer, standard, enterprise, web edition. Only SQL server Express edition do not support SQL server agent.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

SQL Server Express Edition do not have a SQL Server Agent, so what you are seeing is correct and it won't work if you enable the service.

https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#SSMS

Answer 3

Yes. Developer edition includes SQL Agent. Developer edition is Enterprise Edition.

See:
https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#SSMS