SQL Server (SQLEXPRESS) and SQL Server Agent (SQLEXPRESS)

Question

I came across these two services separately running in Services.msc -

• SQL Server (SQLEXPRESS) - started+Automatic
• SQL Server Agent (SQLEXPRESS) - Disabled

Can you please guide why do we need SQL Server Agent (SQLEXPRESS)?

Thank you!

Ethnogeny

It's optional and, as you've said, disabled by default. It's a SQL-server-based scheduled jobs service, useful for running SQL tasks such as database clean-ups or even backups. If you're worried about the installation footprint I doubt it's much at all on top of the rest of SQL server. – Kotz

@Rup, you should make that an answer, I'd upvote it. – Misjoinder

Giorgi beat me to it with the link, which more or less says all of that. – Kotz

Dont forget that the express edition of SQL server does not have the agent function. The service is there but will not start if you try to run it – Badenpowell

Answer 1

SQL Server Agent is used for running jobs: About SQL Server Agent

Novah