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)
 job schedule

Author  Topic 

djokerss
Starting Member

28 Posts

Posted - 2006-09-27 : 13:03:39

is there a way to make a job schedule that running store procedure for msql express ?

i'd like to make a time counter that will update every minute.

thanks

mightypenny_ph
Yak Posting Veteran

54 Posts

Posted - 2006-11-06 : 06:39:45
unfortunately, from what i've read. SQL Server 2005 Express doesn't support SQL jobs because SQL Agent is not support. What Microsoft advised is to used Windows tasks scheduler as the replacement for SQL Agent... Please see link below. What i've been doing is to create a tasks that will execute a stored procedure or etc using SQLCMD utility.

http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx


SlayerS_`BoxeR` + [ReD]NaDa
Go to Top of Page
   

- Advertisement -