By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,564 Members | 1,081 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,564 IT Pros & Developers. It's quick & easy.

Creating maintenance plan wizard problem

P: n/a
Hi!

When I try to create maintenance plan using wizard in SQL Management Studio
for SQL Server 2005 Standard Edition, I get the following error:
TITLE: Maintenance Plan Wizard Progress
------------------------------

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)
I tried the links for this errors, but Microsoft says no additional
information available.

Can you please help me?

Best regards,
Zvonko

Feb 9 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.