Sunday, February 19, 2012

Error in Adding Maintenance Plan

Below is the Error ( I have SSIS installed ; when I open Business
Intelligence Studio it lists SSIS as installed)

Maintenance Plan Wizard Progress

- Creating maintenance plan "Backup xxxDatabases" (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=...


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=...

- Adding tasks to the maintenance plan (Stopped)

- Adding scheduling options (Stopped)

- Adding reporting options (Stopped)

- Saving maintenance plan "Backup SCS Databases" (Stopped)

Please advise

Jishnu,

I'm going to move your thread to the Integration Services forum where I think you will get a better response.

-Jeffrey

No comments:

Post a Comment