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

About author

Vittorio Pavesi


  1. Thanks. You saved me from pulling my hair out!

  2. Anonymous
    4:40 AM

    Thanks, Me too

  3. Jim Carrey
    1:28 AM

    Snowboarders actually do make some contributions to society. Thanks!

  4. Anonymous
    1:50 PM

    Thanks, you help me so much.

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

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

Post a Comment