SQL 2005/2008 Express SQL Agent Question

Question

Post reply

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:-)

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Florian Reischl SSC-Dedicated Points: 37301 More actions · Answer 1

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 · Answer 2

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 · Answer 3

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].