如何通过 T-SQL 在 SQL Server 2008 中创建计划作业？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15391936/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to create a scheduled job in SQL server 2008 via T-SQL?
提问by saeed
I want to create a job which deletes records from a database after a period of time has passed. For example I have a field in news table Time Stampand each month a SQL query runs like a scheduled job against my database and deletes news where the time stamp is two month old. Generally I want to delete news for 2 month ago and older to not let my table become a large table. How can I accomplish this?
我想创建一个作业，在一段时间后从数据库中删除记录。例如，我在新闻表中有一个字段，Time Stamp每个月都有一个 SQL 查询像针对我的数据库的预定作业一样运行，并删除时间戳为两个月前的新闻。一般来说，我想删除 2 个月前及更早的新闻，以免我的桌子变成一张大桌子。我怎样才能做到这一点？
回答by saeed
you should create a jobin SQL below is a sample T-SQL for create a job via SQL agent
你应该创建一个作业以下SQL是一个示例T-SQL的创建通过SQL代理工作
USE msdb ;
GO
EXEC dbo.sp_add_job
@job_name = N'Weekly Sales Data Backup' ;
GO
EXEC sp_add_jobstep
@job_name = N'Weekly Sales Data Backup',
@step_name = N'Set database to read only',
@subsystem = N'TSQL',
@command = N'ALTER DATABASE SALES SET READ_ONLY',
@retry_attempts = 5,
@retry_interval = 5 ;
GO
EXEC dbo.sp_add_schedule
@schedule_name = N'RunOnce',
@freq_type = 1,
@active_start_time = 233000 ;
USE msdb ;
GO
EXEC sp_attach_schedule
@job_name = N'Weekly Sales Data Backup',
@schedule_name = N'RunOnce';
GO
EXEC dbo.sp_add_jobserver
@job_name = N'Weekly Sales Data Backup';
GO
回答by Fls'Zen
You will need to create a SQL Agent Jobto schedule a job to periodically run. If you want to create the job with T-SQL, refer to How to: Create a SQL Server Agent Job (Transact-SQL).
您将需要创建一个SQL 代理作业来安排定期运行的作业。如果要使用 T-SQL 创建作业，请参阅如何：创建 SQL Server 代理作业 (Transact-SQL)。
