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

Article translations Article translations
Article ID: 953118 - View products that this article applies to.
Expand all | Collapse all

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: May 29, 2008 - Revision: 1.1
APPLIES TO
  • 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
Keywords: 
kbexpertiseadvanced kbtshoot kbprb KB953118

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com