MS SQL Server - Can't create a Maint Plan in 2005

Author

Can't create a Maint Plan in 2005

2006-03-08, 8:23 pm

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_sub
systems) (Microsoft SQL Server Error:14234)

It's on a clustered system.

TIA - Jeff.

Andrew J. Kelly

2006-03-08, 8:23 pm

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_sub
systems) (Microsoft SQL Server
> Error:14234)
>
> It's on a clustered system.
>
> TIA - Jeff.
>

Sponsored Links