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)
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)
========================================
To resolve this behavior, install the Integration Services service from the SQL Server 2005 CD. To do this, follow these steps:
- Run the SQL Server Installation Wizard.
- On the System Configuration Check page, click Next after the scan is complete.
- In the Name box and in the Company box, enter the appropriate information, and then click Next.
- Click to select the Integration Services check box, and then click Next.
- Click Next, and then click Install.
- When the installation is complete, click Next, and then click Finish.
Không có nhận xét nào:
Đăng nhận xét