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