PRINT ‘ @active_start_time=’+RTRIM(@active_start_time)+’, ‘
PRINT ‘ @active_end_time=’+RTRIM(@active_end_time)+’, ‘
PRINT ‘ @schedule_uid=N”’+RTRIM(NEWID())+””
PRINT ‘ IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback’
END
PRINT ‘ EXEC @ReturnCode = msdb.dbo.sp_add_jobserver @job_id = @jobId, @server_name = N”’+@server+””
PRINT ‘ IF (@@ERROR <> 0 OR @ReturnCode <> 0) GOTO QuitWithRollback’
PRINT ‘COMMIT TRANSACTION’
PRINT ‘GOTO EndSave’
PRINT ‘QuitWithRollback:’
PRINT ‘ IF(@@TRANCOUNT>0)ROLLBACK TRANSACTION’
PRINT ‘EndSave:’
PRINT ‘ ‘
PRINT ‘GO’
您可能感兴趣的文章:sql server代理中作业执行SSIS包失败的解决办法SQL Server 2012 创建定时作业(图文并茂，教你轻松快速创建)SQL Server 作业同步 (结合备份作业)SQL SERVER数据库的作业的脚本及存储过程SQLServer2005创建定时作业任务SQL Server 2005作业设置定时任务sql server定时作业调用Kettle job出错的快速解决方法SQL Server Alwayson创建代理作业的注意事项详解SQL Server作业报错特殊案例分析
