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

sql-server sql-server-express sql-server-agent
inutan picture inutan · Oct 19, 2010 · Viewed 21.3k times · Source

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!

Answer

Giorgi picture Giorgi · Oct 19, 2010

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

Related questions

How can I determine installed SQL Server instances and their versions?

I'm trying to determine what instances of sql server/sql express I have installed (either manually or programmatically) but all of the examples are telling me to run a SQL query to determine this which assumes I'm already connected to …

Read More
SQL Server after update trigger

I have a problem with this trigger. I would like it to update the requested information only to the row in question (the one I just updated) and not the entire table. CREATE TRIGGER [dbo].[after_update] ON [dbo].[MYTABLE] …

Read More
SQL Server Express CREATE DATABASE permission denied in database 'master'

After I change the option as UserInstance="False", then the error starts to happen. Because I want to use full-text search, the option change is required. BUT, it stopped to work. Is there any way to make it work again? …

Read More