Sql Server 2005 Express and Windows Task Scheduler | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Sql Server 2005 Express and Windows Task Scheduler

Since SQL Server 2005 Express does not come with SQL Server Agent, how can I set up jobs to execute stored procedures which will update tables? I think I may need to use Windows Task Scheduler but I don’t know how to call Windows Task Scheduler from SQL Server and also how to update the schedules. Thanks.
You could use Windows Tas Scheduler to run sql scripts using the SQLCMD utility. I don’t think you will be able to get SQl to talk to Windows Task Scheduler though… not sure why you would want to either. I’ve not sure if SQLCMD comes with express edition or not but you can download it from MS if not. Simon
KBAhttp://support.microsoft.com/kb/162294/en-us about what Simon referred. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.