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.




Related Articles :

  • No Related Articles Found

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

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |