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

msdb.dbo.syssubsystems

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.




Array

No comments yet... Be the first to leave a reply!