Subsystem % could not be loaded 或 error:c001f001

  • 1708
  • 0

Subsystem % could not be loaded 或 error:c001f001

Restore或附加 MSDB 之後,若出現「Subsystem % could not be loaded」或SQL agent job有以下錯誤訊息,

clip_image001

應該是子系統dll檔的path與msdb.dbo.syssubsystems裡所記錄不符。可先清空msdb.dbo.syssubsystems,再執行msdb.dbo.sp_verify_subsystems重新建立dll檔的位置。

USE msdb

GO

DELETE FROM msdb.dbo.syssubsystems

EXEC msdb.dbo.sp_verify_subsystems 1

GO

 

 

Reference

http://support.microsoft.com/kb/2315727/zh-tw

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/1c32a31f-7413-4d11-91c8-d10b6dc5b08e