sqlserver2008 使用系统用户作为job owner执行失败的bug

最近频繁出现使用job执行备份均失败，修改job 的owner为sa以后执行就ok了，不知其原因为何，错误如下：

The?job?failed.??The?owner?(test-zuoqujiaAdministrator)?of?job?Job_test_FULLBACKUP?does?not?have?server?access.

最近有时间做了下研究，来自微软官网的说明如下：

• In SQL Server 2008 or SQL Server 2005,you create a job whose owner is a Windows user account.

• You run the job and the job works well.

• You restart the SQL Server Agent.

• You run the job again.

In this scenario,you may receive the following error message:

The job failed. The owner () of job <Job Name> does not have server access.

When SQL Server Agent starts,the job details will be loaded into the cache. However,when the job owner is a Windows user account,the agent may fail to find the job owner details in the cache and does not refresh the cache. Therefore,the job fails.

然后就不用多说了，解决方法就是打补丁包或者使用其他用户作为job owner啦。

更多官网内容详见：

http://support.microsoft.com/kb/969611/en-us/

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!