开发者

Scheduling daily task on SQL Server 2008 database

开发者 https://www.devze.com 2023-02-04 20:06 出处：网络

I\'m using SQL Server 2008 and trying to make schedule to run a page every mi开发者_StackOverflow社区d-night but I don\'t know how to do it. I already tried to do with SQL JOBS but couldn\'t find JOB

相关专题：sql sql-server-2008 sql-server-2008-express

I'm using SQL Server 2008 and trying to make schedule to run a page every mi开发者_StackOverflow社区d-night but I don't know how to do it. I already tried to do with SQL JOBS but couldn't find JOB folder.

If you are using a full SQL Server product (not Express), just follow the steps from Books Online

http://msdn.microsoft.com/en-us/library/ms191439%28v=SQL.100%29.aspx

FYI - The folder "Jobs" is under "SQL Server Agent" in the Object Explorer tree.

If you are asking about Express, then refer to answers in this SO question or a neat trick using SQL Server Service Broker

to schedule PAGE (script) running look in Task Manager