troubleshooting Question

All SubPlans for Maintenance Plan fail

Avatar of Cyrun
CyrunFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
9 Comments1 Solution1486 ViewsLast Modified:
I created a maintenance plan using the plan wizzard. The plan has five different subplanwith different schedules for each subplan. When I try to run any of the sub plans I get this error:

Date            12/16/2009 8:36:25 AM
Log            Job History (AllianceMaintenancePlan.Subplan_4)

Step ID            1
Server            {hidden}
Job Name            AllianceMaintenancePlan.Subplan_4
Step Name            Subplan_4
Duration            00:00:31
Sql Severity            0
Sql Message ID            0
Operator Emailed            
Operator Net sent            
Operator Paged            
Retries Attempted            0

Executed as user: {hidden}\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 32-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  8:36:25 AM  Warning: 2009-12-16 08:36:56.33     Code: 0x80012017     Source: AllianceMaintenancePlan      Description: The package path referenced an object that cannot be found: "\Package\Subplan_4.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\Subplan_4.Disable value to false.  Started:  8:36:25 AM  Finished: 8:36:56 AM  Elapsed:  30.859 seconds.  The package execution failed.  The step failed.
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 9 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros