Hello,
i try to create a new maintenance plan in the sql management studio.
i tried it with windows xp (x86, german), 2003 enterprise / standard (both
x64 and english), sql server developer x86/x64 (english and german),
enterprise x64 (english).
to create it i use the wizard, every time and constellation ends with the
same error:
steps:
1) select windows authentication (same with sa in sql authentication)
2) check database integrity (or any other job)
3) select database master (or any other)
4) not scheduled (no other effect if scheduled)
5) no reporting (no other effect if reported)
6) Finish
Error:
Maintenance Plan Wizard Progress
- Creating maintenance plan "MaintenancePlan" (Error)
Messages
* 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
- Adding tasks to the maintenance plan (Stopped)
- Adding scheduling options (Stopped)
- Adding reporting options (Stopped)
- Saving maintenance plan "MaintenancePlan" (Stopped)
Has anyone any idea about thies?I'm not sure but perhaps you get this error if you didn't install Integration Services...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> Hello,
> i try to create a new maintenance plan in the sql management studio.
> i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> x64 and english), sql server developer x86/x64 (english and german),
> enterprise x64 (english).
> to create it i use the wizard, every time and constellation ends with the
> same error:
> steps:
> 1) select windows authentication (same with sa in sql authentication)
> 2) check database integrity (or any other job)
> 3) select database master (or any other)
> 4) not scheduled (no other effect if scheduled)
> 5) no reporting (no other effect if reported)
> 6) Finish
> Error:
> Maintenance Plan Wizard Progress
> - Creating maintenance plan "MaintenancePlan" (Error)
> Messages
> * 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
> - Adding tasks to the maintenance plan (Stopped)
> - Adding scheduling options (Stopped)
> - Adding reporting options (Stopped)
> - Saving maintenance plan "MaintenancePlan" (Stopped)
> Has anyone any idea about thies?
>|||thank you, this seems to be the solution!
"Tibor Karaszi" schrieb:
> I'm not sure but perhaps you get this error if you didn't install Integration Services...
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Sorcerer" <Sorcerer@.discussions.microsoft.com> wrote in message
> news:D2C35CAD-1CE9-4F7F-9FB0-DDB6BABD670E@.microsoft.com...
> > Hello,
> >
> > i try to create a new maintenance plan in the sql management studio.
> > i tried it with windows xp (x86, german), 2003 enterprise / standard (both
> > x64 and english), sql server developer x86/x64 (english and german),
> > enterprise x64 (english).
> > to create it i use the wizard, every time and constellation ends with the
> > same error:
> >
> > steps:
> > 1) select windows authentication (same with sa in sql authentication)
> > 2) check database integrity (or any other job)
> > 3) select database master (or any other)
> > 4) not scheduled (no other effect if scheduled)
> > 5) no reporting (no other effect if reported)
> > 6) Finish
> >
> > Error:
> > Maintenance Plan Wizard Progress
> > - Creating maintenance plan "MaintenancePlan" (Error)
> > Messages
> > * 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
> > - Adding tasks to the maintenance plan (Stopped)
> > - Adding scheduling options (Stopped)
> > - Adding reporting options (Stopped)
> > - Saving maintenance plan "MaintenancePlan" (Stopped)
> >
> > Has anyone any idea about thies?
> >
>
>sql
Wednesday, March 21, 2012
No ability to create maintanance plan in sql server 2005
Labels:
ability,
create,
database,
enterprise,
german,
maintanance,
maintenance,
management,
microsoft,
mysql,
oracle,
plan,
server,
sql,
standard,
studio,
windows,
x86
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment