维护计划job不能成功执行

Question

已以用户 WYSVR101\SYSTEM 的身份执行。 Microsoft (R) SQL Server 执行包实用工具  Version 10.50.1600.1 for 64-bit  版权所有 (C) Microsoft Corporation 2010。保留所有权利。    开始时间:  1:33:30  错误: 2010-09-01 01:33:30.64     代码: 0xC0011009     源: {4F9D255E-C2FE-47EC-9A45-1975F5F3E760}      说明: 无法创建 XML 文档对象模型的实例。可能未注册 MSXML。  错误结束  由于出现错误 0x80040154，导致无法加载包“Maintenance Plans\dataBak”。  说明: 没有注册类别  源:   开始时间:  1:33:30  完成时间: 1:33:30  占用时间:  0.063 秒.  无法加载该包。.  该步骤失败。

象这样的问题,有什么好的解决方案,是不是只有重新覆盖安装sql?

请各位专家帮忙,谢谢!

Answer 1

What's your sql2k8 r2 edition? Tried change job owner to sa?

Answer 2

SQL Server Agent 服务是否已经启动？

Answer 3

你说对了,是sql2008r2版本,所有者一直是sa的,呵呵

Answer 4

agent肯定是起来了,呵呵

而且手动执行过job的

Answer 5

What steps do you have in maintenance plan? Which maintenance step doesn't run? By the way, edition is different from version. Sql server have several editions like enterprise, standard, express and so. Some of them don't support maintenance plan.

Answer 6

代理服务最好别用系统内置账户

Answer 7

What steps do you have in maintenance plan? Which maintenance step doesn't run? By the way, edition is different from version. Sql server have several editions like enterprise, standard, express and so. Some of them don't support maintenance plan.

还有个现象没有说的就是:另外的一台服务器也是同样的版本,而且也是用的是内置账号,但这台服务器是没有问题的.都是企业版.

Answer 8

代理服务最好别用系统内置账户

嗯,这个是改注意,但不是根本的原因.因为另外一台服务器也是这样的配置.

Answer 9

What steps do you have in maintenance plan? Which maintenance step doesn't run? Any info in plan's log files?