getting error from maint jobs after migration to sql 2005
Posted on 2008-06-20
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.