sqlserver2008 使用系统用户作为job owner执行失败的bug
最近频繁出现使用job执行备份均失败，修改job 的owner为sa以后执行就ok了，不知其原因为何，错误如下：
The job failed. The owner (test-zuoqujia\Administrator) 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/
本文出自 “composer” 博客，请务必保留此出处http://zuoqujia.blog.51cto.com/9151800/1585439
郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。
