Right now I have the express version and I need some automated work done and thus, I need the agent in my SSMS, my question is:
Which edition has the agent? On the website I've seen...
Enterprise,
standard - per core,
standard - server + CAL,
Developer,
Web,
Express
SQL Server Express doesn't support SQL Server Agent.
SQL Server Enterprise, standard, Developer, Web all support SQL Server Agent.
By the way, You can also see the SQL Server Agent Service of the SQL Server Express instance in the Sql Server Configuration Manager. But you can't start it. You will get the error message like the below picture.