Re: Cannot create a Manintenance Plan in SQL Server 2005

Make sure that both the SQL Agent and SSIS services are running by using the
SQL Server Configuration Manager.

--
Andrew J. Kelly SQL MVP


"Jan Nøtland" <jan@xxxxxx> wrote in message
news:efgS0X4DGHA.2724@xxxxxxxxxxxxxxxxxxxxxxx
> 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
> ------------------------------
>
>


.