Re: Cannot create a Manintenance Plan in SQL Server 2005

"Jan Nøtland" <jan@xxxxxx> wrote in
news:efgS0X4DGHA.2724@xxxxxxxxxxxxxxxxxxxx:

> This used to be so easy in SQL Server 2000!
>
> And it look equally easy in 2005, but I can't make it work.
> I'm using the Maintenance Plan Wizzard to set up a Back Up Database
> (Full) Job
> I select teh databases that I want backed up and create a schedule
> At the point where I press Finish to crate the plan, I get: Error:
> Creating the Maintenance Plan... Adding tasks, scheduling options,
> reporting options and saving the plan is stopped. Please review the
> error message text below: None of the help options is of any
> assistance.
>
> Is there something I'm missing? Please help. Thanks.
>
> Hilsen/Regards
>
> Jan Nøtland jan@xxxxxx
> MEC AS www.mec.no
> tel. +47 38272213
> mob. +47 90784824
>
>
> TITLE: Maintenance Plan Wizard Progress
> ------------------------------
>
> Create maintenance plan failed.
>
> ------------------------------
> ADDITIONAL INFORMATION:
>
> Create failed for JobStep 'Subplan'.
> (Microsoft.SqlServer.MaintenancePlanTasks)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=
9.
> 00.1399.00
&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates
> .FailedOperationExceptionText&EvtID=Create+JobStep&LinkId=20476
>
> ------------------------------
>
> 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)
>
> For help, click:
> http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=
09
> .00.1399&EvtSrc=MSSQLServer&EvtID=14234&LinkId=20476
>
> ------------------------------
> BUTTONS:
>
> OK
> ------------------------------

Do you have SSIS (SQL Server Integration Services) Installed?

http://msdn2.microsoft.com/en-us/library/ms189036.aspx :
"The maintenance plan feature of SQL Server Database Engine requires
components of SQL Server 2005 Integration Services (SSIS). To create or
execute maintenance plans, you must install SSIS."

Without SSIS Installed I get exactly the same error message as you.

--
Ole Kristian Bangås
MCT, MCDBA, MCDST, MCSE:Security, MCSE:Messaging
.