SQL Jobs Suspended after restoing msdb Database

When we run jobs which already configured then we may gett the msg saying that "job already suspended" then it fail.

It should be the cause after restoring/Attaching the msdb Database from other server.The paths to the SQL Server Agent subsystem DLLs are stored in the msdb.dbo.syssubsystems table in the msdb database. The locations do not correspond to the current locations of the binaries for the instance of SQL Server.

Solution:
Delete the entries from msdb.dbo.syssubsystems table and then repopulate the entries.


use msdb
go
delete from msdb.dbo.syssubsystems--delete entries in syssubsystems
exec msdb.dbo.sp_verify_subsystems 1-- Update the susbsystem DLL's to the correct path on the current install Folder.


Finally we should restart the SQl Agent service to effect the change.