SQL Agent job getting suspended.
When you run some SQL Server agent jobs they will be suspended and you will not be permitted to re-run them.
This is due the issues with the SQL Server Agent subs system information which can be obtained from themsdb.dbo.syssubsystems table.
To do this execute:
SELECT * FROM
The output for this is shown below:
Sometimes the relevant sub system data might be incorrect. You may need to run following script and re-start the SQL Serve Agent job.
– Delete the existing rows.
DELETE FROM msdb.dbo.syssubsystems
– Fill the table with new rows pointing to the proper location of the DLLs.
EXEC msdb.dbo.sp_verify_subsystems 1
This procedure is simply updating the above table getting relevant data from the registry.