Sql job and Sql job scheduler in sqlserver 2005 ee

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Express Edition and Compact Edition (2005)

Sql job and Sql job scheduler in sqlserver 2005 ee

Author

Topic

dazy
Starting Member

3 Posts

Posted - 2010-02-23 : 09:07:58

Hi,

I want to create sql job and sql job scedular like this

http://www.aspsnippets.com/Articles/Automated-Email-Notifications-using-SQL-Server-Job-Schedular.aspx

But I have sql server 2005 express edition on my PC and SQL Server Express Edition does not have SQL Agent.

So any one can tell me how can I create sql job and sql job scheduler with sql server express edition.

Regards,
dazy

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-23 : 09:42:34

without sql agent it is not possible.
Maybe here are some useful informations:
http://weblogs.sqlteam.com/mladenp/archive/2008/08/28/SQL-Server-2005-Express-Job-Scheduling---Part-1.aspx

No, you're never too old to Yak'n'Roll if you're too young to die.

dazy
Starting Member

3 Posts

Posted - 2010-02-23 : 10:54:57

Then how can I get SQL Agent?

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-02-23 : 11:03:24

If it is only for testing and so on then buy a developer edition of sql server (maybe 50 EURO).
developer edition comes up with all you need.

edit: by --> buy

No, you're never too old to Yak'n'Roll if you're too young to die.

dazy
Starting Member

3 Posts

Posted - 2010-02-23 : 11:08:16

Thanks for the link you posted here.

But this only explains how to schedule sql jobs? But I also want to know a step ahead of this i.e. how to create sql jobs in sql server express edition.

Regards,
dazy

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources