您需要使用SQL Server代理创建可根据您的要求安排的作业。



如何：安排作业（SQL Server Management Studio） [ ^ ]

You need to use SQL Server Agent for creating the job which you can schedule as per your requirement.

How to: Schedule a Job (SQL Server Management Studio)[^]

您可以在SQL2008中创建数据库作业并指定您的SP /包来处理和配置它何时运行等。

启动Management Studio然后使用Object资源管理器转到

SQLNode>> Sql Server代理>>工作

右键单击它并选择新工作



此链接mig ht help

msdn.microsoft.com/en-us/library/ms190268(v = sql.100）.aspx

You can create Database job in SQL2008 and assign your SP/Package to process and configure it when to run etc.
Start Management Studio then using Object explorer Go to
SQLNode>>Sql Server Agent>>Job
Right click it and select New Job

This link might help
msdn.microsoft.com/en-us/library/ms190268(v=sql.100).aspx