?
Solved

getting error from maint jobs after migration to sql 2005

Posted on 2008-06-20
4
Medium Priority
?
1,020 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 1500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 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