sqlserver 使用脚本创建作业 (by me)
摘要：
use mastergo--定义创建作业DECLARE @jobid uniqueidentifier, @jobname sysnameSET @jobname = N'testInterval'IF EXISTS(SELECT * FROM msdb.dbo.sysjobs WHERE name=@jobname)EXEC msdb.dbo.sp_delete_job @job_name=@jobnameEXEC msdb.dbo.sp_add_job@job_name = @jobname,@job_id = @jobid OUTPUT--定义作业步骤DECLARE @s 阅读全文
posted @ 2013-02-18 14:04 passer1991 阅读(791) 评论(0) 推荐(0) 编辑
