SQL 2005/2008 Express SQL Agent Question

• drodriguez-762178

  SSCommitted

  Points: 1795

  More actions

  March 26, 2009 at 10:47 am

  #201600

  SQL Forum:

  I'm unfamiliar with SQL 2005 and SQL 2008 Express Edition. I would like to know if either edition come with the SQL Agent. If not, what would be the subsitute? Now, I know the Standard Edition comes with it.

  I'd appreciate anyone's help on this.

  Thanks.

  Dave:-)

• Florian Reischl

  SSC-Dedicated

  Points: 37301

  More actions

  March 26, 2009 at 10:51 am

  #966857

  Hi

  SQL Server Express Editions don't contain the SQL Server Agent. See:

  http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx

  Which substitute? It depends on your requirements. If you need to schedule simple tasks have a look to the windows task scheduler (which became much better within Windows Server 2008!).

  Greets

  Flo

• drodriguez-762178

  SSCommitted

  Points: 1795

  More actions

  March 26, 2009 at 10:55 am

  #966863

  That's what I was looking for. I think I can manage using Windows scheduler.

  Thanks for you help.

  Dave:-)

• Mohit K. Gupta

  SSChampion

  Points: 12130

  More actions

  March 26, 2009 at 11:38 pm

  #967207

  Also have a look at this ...

  http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express

  http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express-2

  I have not read the entire article yet but seems like an interesting idea :).

  Mohit.

  [font="Arial"]---

  Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
  Microsoft FTE - SQL Server PFE

  * Some time its the search that counts, not the finding...
  * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

  How to ask for help .. Read Best Practices here[/url].