Monday, March 19, 2012

Error when creating a maintenance plan

When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
the finish button the following error occurs when trying to create the
plan.
Maintenance Plan Wizard Progress
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)
The job appears in the Job Activity Monitor but greyed out and the
maintenance plan is not listed in its section.
What has caused this issue and how can I resolve it?You need to apply at least SP1 to your SQL Server instance to make
Maintanence Plan work properly. It'd be better if you apply SP2, it contains
lots of fixes.
--
Ekrem Önsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> 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)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?|||Addition: If you do not install SSIS you'll not be able to use Maintanence
Plans in RTM version of SQL Server 2005. It's possible to use Maintanence
Plans without SSIS if you apply SP2.
--
Ekrem Önsoy
"Robin9876" <robin9876@.hotmail.com> wrote in message
news:9c65cf4b-d7b1-4224-bc11-46da57c143c3@.i12g2000prf.googlegroups.com...
> When using the maintenance plan wizard on SQL 2005 (RTM) when pressing
> the finish button the following error occurs when trying to create the
> plan.
> Maintenance Plan Wizard Progress
> 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)
>
> The job appears in the Job Activity Monitor but greyed out and the
> maintenance plan is not listed in its section.
> What has caused this issue and how can I resolve it?

No comments:

Post a Comment