Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed"

Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed"

Symptoms

When you create a new maintenance plan that runs on a schedule in Microsoft SQL Server 2005, you may receive the following error message:
Create maintenance plan failed.

Additional information:
Create failed for JobStep 'Subplan'. (Microsoft.SqlServer.MaintenancePlanTasks)

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

The specified '@subsystem' is invalid (valid values are returned by sp_enum_sqlagent_subsystems). (Microsoft SQL Server, Error 14234)
This behavior may occur when you create the maintenance plan manually or by using the Maintenance Plan Wizard.

↑ Back to the top

Cause

This behavior occurs when you install SQL Server 2005 without installing the SQL Server 2005 Integration Services (SSIS) service. When you create the maintenance plan, the following code is run. 
EXEC msdb.dbo.sp_update_jobstep @job_name=N'System DB Maintenance Plan', @step_id=1 , @subsystem=N'SSIS', @command=N'/SQL 
"\Maintenance Plans\System DB Maintenance Plan" /SERVER ASHBSQL701 /MAXCONCURRENT " -1 " /CHECKPOINTING OFF'
This code tries to access the Integration Services service.

↑ Back to the top

Resolution

To resolve this behavior, install the Integration Services service from the SQL Server 2005 CD. To do this, follow these steps:
  1. Run the SQL Server Installation Wizard.
  2. On the System Configuration Check page, click Next after the scan is complete.
  3. In the Name box and in the
    Company box, enter the appropriate information, and then click Next.
  4. Click to select the Integration Services check box, and then click Next.
  5. Click Next, and then click
    Install.
  6. When the installation is complete, click
    Next, and then click Finish.

↑ Back to the top

Status

This behavior is by design.

↑ Back to the top

More Information

For more information, visit the following Microsoft Developer Network (MSDN) Web sites:
SQL Server Integration Services (SSIS)
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

How to create a maintenance plan
http://msdn2.microsoft.com/en-us/library/ms189953.aspx

↑ Back to the top

Keywords: kb, kbprb, kbentirenet, kbbug, kbinfo, kbtshoot, kbsql2005ssis

↑ Back to the top

Article Info
Article ID : 909036
Revision : 7
Created on : 8/19/2020
Published on : 8/20/2020
Exists online : False
Views : 113