Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 909036 - Last Review: March 20, 2006 - Revision: 1.1
Error message when you create a new maintenance plan in SQL Server 2005: "Create maintenance plan failed"
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.
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.
To resolve this behavior, install the Integration Services service from the
SQL Server 2005 CD.
To do this, follow these steps:
- Run the SQL Server Installation Wizard.
- On the System Configuration Check page, click Next after the scan is complete.
- In the Name box and in the
Company box, enter the appropriate information, and then click Next.
- Click to select the Integration Services check box,
and then click Next.
- Click Next, and then click
Install.
- When the installation is complete, click
Next, and then click Finish.
This
behavior is by design.
For more information, visit the following Microsoft
Developer Network (MSDN) Web sites:
APPLIES TO
- Microsoft SQL Server 2005 Enterprise Edition
- Microsoft SQL Server 2005 Standard Edition
- Microsoft SQL Server 2005 Developer Edition
| kbsql2005ssis kbtshoot kbinfo kbbug kbprb KB909036 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate