SQL Server - SQL server 2008 Express: Schedule job

Asked By dev rathore on 20-May-13 02:01 AM

Hi,

   
I want to schedule job in SQL Server 2008 Express edition, but I didn't find  Server Agent  in it. How Can I schedule job for express edition.

 Let me know pls.

Thanks
Devendra

Danasegarane Arunachalam replied to dev rathore on 20-May-13 05:46 AM
Refer this one : http://www.sqlteam.com/article/scheduling-jobs-in-sql-server-express
dev rathore replied to Danasegarane Arunachalam on 20-May-13 07:59 AM
But i need workround for SQL server 2008
Danasegarane Arunachalam replied to dev rathore on 24-May-13 08:26 PM
Checkout these two links

http://stackoverflow.com/questions/7201061/how-to-create-jobs-in-sql-server-express-edition

and

http://geekswithblogs.net/JaydPage/archive/2011/02/19/automating-the-backup-of-a-sql-server-2008-express-database.aspx

They say sqlserver management studio not included in express edition, try the command line option given