Disclaimer:Hey Guys, this post contains affiliate link to help our reader to buy best product\service for them. It helps us because we receive compensation for our time and expenses.

Note:  Best viewed in Internet Explorer 6 and above

Error: The SQL server job is in suspended mode-Unable to start execution of step 1 (reason: The %s subsystem failed to load [see the SQLAGENT.OUT file for details]; The job has been suspended). The step failed.

Infrastructure: SQL server 2005 and onward

Scenario: While I was working on database migration project for one of the my client and since it was SQL2005 32bits to SQL 2005 64bits migration project, I had replaced msdb database from sql server2005(32-bits) to sql server2005(64-bits) msdb database backup. Since the installation directory had been changed while replacing resulted in old directory entry in table ‘msdb.dbo.syssubsystems’


1.First take the backup of msdb database of newly migrated sql server.
2. Delete the old entry which showing the old directory by running the t-sql command [DELETE FROM msdb.dbo.syssubsystems]
3. Fill the table with new rows pointing to the proper location of the DLLs by running  [EXEC msdb.dbo.sp_verify_subsystems 1]
For more info please visit MS official link for the same:-


Hope this helps:)