开发者

Scheduling daily task on SQL Server 2008 database

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

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜