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?

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?

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?

ERROR sql2005 sobre win2000 ad server

hi
when i try to save a maintenance plan
i get an error like
"GUID must have 32 characters y 4 hyphens"
"xxxxxx-xxxxx-...-xxxxx"
this occurs in production
( sql2005 over win 2000 advanced server )
but, on dev environment
( over win 2003 server )
works fine
any idea ?
thanks
--
atte,
Hernánbajopalabra wrote:
> hi
> when i try to save a maintenance plan
> i get an error like
> "GUID must have 32 characters y 4 hyphens"
> "xxxxxx-xxxxx-...-xxxxx"
> this occurs in production
> ( sql2005 over win 2000 advanced server )
> but, on dev environment
> ( over win 2003 server )
> works fine
> any idea ?
> thanks
>
That sounds like a custom message coming from a trigger. Are there
triggers on that table in production that aren't in development?|||no triggers
this is the real error
"GUID should contain 32 digits with 4 dashes"
when trying to save the more easy simple plan
it seems to be a bug
both sql servers reports
different MDAC versions and files ...
could it be the point ' the MDAC '
atte,
Hernán
"Tracy McKibben" <tracy@.realsqlguy.com> escribió en el mensaje
news:ucm2uMVlGHA.5044@.TK2MSFTNGP02.phx.gbl...
| bajopalabra wrote:
| > hi
| > when i try to save a maintenance plan
| > i get an error like
| >
| > "GUID must have 32 characters y 4 hyphens"
| > "xxxxxx-xxxxx-...-xxxxx"
| >
| > this occurs in production
| > ( sql2005 over win 2000 advanced server )
| >
| > but, on dev environment
| > ( over win 2003 server )
| > works fine
| >
| > any idea ?
| > thanks
| >
|
| That sounds like a custom message coming from a trigger. Are there
| triggers on that table in production that aren't in development?|||bajopalabra wrote:
> no triggers
> this is the real error
> "GUID should contain 32 digits with 4 dashes"
> when trying to save the more easy simple plan
> it seems to be a bug
> both sql servers reports
> different MDAC versions and files ...
> could it be the point ' the MDAC '
>
Apparently this is a known bug that is fixed in Service Pack 1
http://support.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.tools&tid=ea561347-3d88-41c2-b475-88bfd478c3ce&p=1|||i think it's fixed on win2003
but not on win2000
i tested in both servers
i found a workareound
as i read on another newsgroup
if i create the plan via wizard
there are no problem
later, i can change the plan as i wish
very rare thing...
atte,
Hernán
"Tracy McKibben" <tracy@.realsqlguy.com> escribió en el mensaje
news:uJc89oVlGHA.3776@.TK2MSFTNGP03.phx.gbl...
| bajopalabra wrote:
| > no triggers
| > this is the real error
| >
| > "GUID should contain 32 digits with 4 dashes"
| >
| > when trying to save the more easy simple plan
| >
| > it seems to be a bug
| >
| > both sql servers reports
| > different MDAC versions and files ...
| > could it be the point ' the MDAC '
| >
| >
|
| Apparently this is a known bug that is fixed in Service Pack 1
|
http://support.microsoft.com/newsgroups/default.aspx?dg=microsoft.public.sqlserver.tools&tid=ea561347-3d88-41c2-b475-88bfd478c3ce&p=1
|