asked on

getting error from maint jobs after migration to sql 2005

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.

zx10r

did you move over the maintenance plans as well?

richa1960

ASKER

I tried but the script kept failing, so i rebuilt them from scratch,

the_kraken

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,

ASKER CERTIFIED SOLUTION

the_kraken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial