SQLserver 中Job 相关脚本

查看job运行情况:

1 2 3 4 5

USE msdb ; GO   EXEC dbo.sp_help_jobactivity ; GO

创建Job

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26

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

 

运行job

1	EXEC msdb.dbo.sp_start_job 'BACKUPTEST'

 

 

 

源地址http://technet.microsoft.com/en-us/library/ms190268.aspx#TsqlProcedure

转载于:https://www.cnblogs.com/shiyinian/p/5160640.html