sp_enum_sqlagent_subsystems 與維護計畫

今天, 想幫MS SQL server 建立維護計畫來建立排程, 定時的備份資料庫, 發生錯誤, 訊息如下:



查了一下, sp_enum_sqlagent_subsystems,
使用語法: sp_enum_sqlagent_subsystems
這個程序會列出執行個體中可用的子系統。

RESOLUTION(解決辦法):
To resolve this behavior, install the Integration Services service from the SQL Server 2005 CD. To do this, follow these steps:

1. Run the SQL Server Installation Wizard.
2. On the System Configuration Check page, click Next after the scan is complete.
3. In the Name box and in the Company box, enter the appropriate information, and then click Next.
4. Click to select the Integration Services check box, and then click Next.
5. Click Next, and then click Install.
6. When the installation is complete, click Next, and then click Finish.


MORE INFORMATION (更多資訊...):
SQL Server Integration Services (SSIS)
http://msdn2.microsoft.com/en-us/library/ms141026.aspx

How to create a maintenance plan
http://msdn2.microsoft.com/en-us/library/ms189953.aspx