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:



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.


Leave a comment

Your email address will not be published.