You are currently offline, waiting for your internet to reconnect

Changes to a SQL Server Agent job are lost when the job corresponds to a subplan in a maintenance plan that you created in SQL Server 2005 Service Pack 2

Extended support for SQL Server 2005 ends on April 12, 2016

If you are still running SQL Server 2005 after April 12, 2016, you will no longer receive security updates and technical support. We recommend upgrading to SQL Server 2014 and Azure SQL Database to achieve breakthrough performance, maintain security and compliance, and optimize your data platform infrastructure. Learn more about the options for upgrading from SQL Server 2005 to a supported version here.

SYMPTOMS
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).
CAUSE
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.
STATUS
This behavior is by design.
MORE INFORMATION
Microsoft does not support the following scenario in SQL Server 2005:
  • You use the Maintenance Plan Wizard to create a maintenance plan.
  • You change SQL Server Agent jobs that correspond to subplans in the maintenance plan.
Properties

Article ID: 953118 - Last Review: 05/29/2008 16:42:07 - Revision: 1.1

Microsoft SQL Server 2005 Express Edition, Microsoft SQL Server 2005 Express Edition with Advanced Services, Microsoft SQL Server 2005 Standard Edition, Microsoft SQL Server 2005 Workgroup Edition, Microsoft SQL Server 2005 Developer Edition, Microsoft SQL Server 2005 Enterprise Edition, Microsoft SQL Server 2005 Enterprise X64 Edition, Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems, Microsoft SQL Server 2005 Standard X64 Edition, Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems

  • kbexpertiseadvanced kbtshoot kbprb KB953118
Feedback
&t=">oFirePV = 1; var varClickTracking = 1; var varCustomerTracking = 1; var Route = "76500"; var Ctrl = ""; document.write("