Article ID: 953118 - View products that this article applies to.
Consider the following scenario. In Microsoft SQL Server 2005 Service Pack 2 (SP2), you use the Maintenance Plan Wizard to create a maintenance plan. Then, you modify a SQL Server Agent job that corresponds to a subplan in the maintenance plan. For example, you add a job step to the SQL Server Agent job. Then, you save the maintenance plan again.
In this scenario, the changes to the SQL Server Agent job are lost.
This behavior does not occur in the release version of SQL Server 2005 or in SQL Server 2005 Service Pack 1 (SP1).
This behavior occurs because the behavior for saving a maintenance plan that is created in the Maintenance Plan Wizard in SQL Server 2005 SP2 changed from earlier versions of SQL Server 2005.
When you save a maintenance plan, SQL Server 2005 SP2 deletes the previous maintenance plan. Then, SQL Server 2005 SP2 re-creates the maintenance plan. When SQL Server 2005 SP2 deletes the maintenance plan, SQL Server 2005 SP2 also deletes the SQL Server Agent jobs that correspond to the subplans in the maintenance plan.
Microsoft does not support the following scenario in SQL Server 2005:
Article ID: 953118 - Last Review: May 29, 2008 - Revision: 1.1
Contact us for more help
Connect with Answer Desk for expert help.