阅读背景:

禁用/启用SQLServer代理作业的正确方法

来源:互联网 

I have a number of SQLServer agent scheduled jobs, one of them performs a full database backup. I want to disable some other jobs when backup begins and re-enable them once backup is done. What is the right way to do so? I was thinking about adding one of the following tsql commands to the first step of the backup task (and respective enable commands to the last step), but I cannot find which one is better (or maybe there is another way).I have a number of SQLServer agent scheduled jo




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: