Maintenance plan(rebuild index) Failed

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Maintenance plan(rebuild index) Failed

Author

Topic

getudaysingh
Starting Member

1 Post

Posted - 2011-07-26 : 05:00:45

Hi,

The SQL Server Maintenance plan is failing :
(
Date 7/23/2011 3:00:01 AM
Log Job History (XXX_RebuildIndex_MaintPlan.Rebuilding_Indexes)

Step ID 1
Server XXXXXXX\YYYYYYYYYY
Job Name XXX_RebuildIndex_MaintPlan.Rebuilding_Indexes
Step Name Rebuilding_Indexes
Duration 00:00:02
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: XXXXXX\ABCD. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 3:00:01 AM Warning: 2011-07-23 03:00:03.33 Code: 0x80012017 Source: XXX_RebuildIndex_MaintPlan Description: The package path referenced an object that cannot be found: "\Package\Rebuilding_Indexes.Disable". This occurs when an attempt is made to resolve a package path to an object that cannot be found. End Warning DTExec: Could not set \Package\Rebuilding_Indexes.Disable value to false. Started: 3:00:01 AM Finished: 3:00:03 AM Elapsed: 2.013 seconds. The package execution failed. The step failed.
)

# SQL Server 2005 Maintenance plan is failing since it was created, past 1 year.
# I am able run the T-SQL script in query analyzer successfully.
# I am getting same errors for all maintenance plan on 2 machines(Windows Server 2008) in two node (Active-Active) cluster environment.
# Does re-registering the DTS.dll on both the nodes will resolve this issue? If yes then, Please provide the steps to re-register it on nodes in a cluster environment.
# Is it failing due to some other reasons?

Please let me know how to resolve this issue.
Thanks in advance.

Uday

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2011-07-26 : 06:09:25

Find what happened to \Package\Rebuilding_Indexes.Disable and add it back into the package, or change the logic in the package.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources