SQL 2005: The specified '@subsystem' is invalid (Error 14234)

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 problem occur because you didn't install Integration Services service from the SQL Server 2005 CD, just add the component and the error will not appear again.

Source: http://support.microsoft.com/kb/909036/en-us
Share on Google Plus

About Vittorio Pavesi

    Blogger Comment
    Facebook Comment

6 comments:

John Walker said...

Thanks. You saved me from pulling my hair out!

Anonymous said...

Thanks, Me too

Jim Carrey said...

Snowboarders actually do make some contributions to society. Thanks!

Anonymous said...

Thanks, you help me so much.

Brad said...

Just saying thanks for this! You helped keep my testing right on schedule!

Gabriel said...

In my case I still got this error until I started SQL Server Agent service that was set on manual start.