Saturday, February 25, 2012

Can't create a Maint Plan in 2005

I am trying to create a maint plan in 2005 and no matter what types of
things I tell it to do, when it goes to create the plan I get the following
error message:
Create maint plan failed.
Additional information:
create failed for jobstep 'Subplan'
An exception occurred while executing a Transact-SQL statement or
batch.
The specified '@.subsystem' is invalid (valid values are returned
by sp_enum_sqlagent_subsystems) (Microsoft SQL Server Error:14234)
It's on a clustered system.
TIA - Jeff.Do you have SQL Agent running and do you have SSIS installed and running?
Andrew J. Kelly SQL MVP
"UJ" <fred@.nowhere.com> wrote in message
news:epT9r3uQGHA.5808@.TK2MSFTNGP12.phx.gbl...
>I am trying to create a maint plan in 2005 and no matter what types of
>things I tell it to do, when it goes to create the plan I get the following
>error message:
> Create maint plan failed.
> Additional information:
> create failed for jobstep 'Subplan'
> An exception occurred while executing a Transact-SQL statement or
> batch.
> The specified '@.subsystem' is invalid (valid values are
> returned by sp_enum_sqlagent_subsystems) (Microsoft SQL Server
> Error:14234)
> It's on a clustered system.
> TIA - Jeff.
>

No comments:

Post a Comment