Solved

getting error from maint jobs after migration to sql 2005

Posted on 2008-06-20
4
1,001 Views
Last Modified: 2008-11-12
i'm getting the error listed below after migrating my databases to my new sql 2005 server, the jobs were fine during the test phase of the migration, but after moving the DB over perminatly the jobs started failing.

Executed as user: MCGPLC\ChiSQLServer. 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:  12:04:16 AM  Warning: 2008-06-20 00:04:17.64     Code: 0x80012017     Source: Maint_plan_system_backups      Description: The package path referenced an object that cannot be found: "\Package\Subplan_1.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_1.Disable value to false.  Started:  12:04:16 AM  Finished: 12:04:17 AM  Elapsed:  0.859 seconds.  The package execution failed.  The step failed.
0
Comment
Question by:richa1960
  • 2
4 Comments
 
LVL 4

Expert Comment

by:zx10r
ID: 21832778
did you move over the maintenance plans as well?
0
 

Author Comment

by:richa1960
ID: 21834342
I tried but the script kept failing, so i rebuilt them from scratch,
0
 

Expert Comment

by:the_kraken
ID: 22059311
Anyone have any luck fixing this?  I had the same issue as richa1960; I moved a maint. plan over to the new server, couldn't get it to run and ended up rebuilding it.  Now I get the error listed above.  Any suggestions or fixes?  Thanks,
0
 

Accepted Solution

by:
the_kraken earned 500 total points
ID: 22060427
I ended up opening the maint. plan itself and setting the schedule from there versus changing it on the scheduled job.  It seems like this shouldn't make a difference but it did in my case.  Hope this helps.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now