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.

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’

Resolution:

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:-

https://support.microsoft.com/en-us/help/914171/error-message-when-you-restore-or-attach-an-msdb-database-or-when-you

Hope this helps:)

Dear Visitors!
To get Best Deals and Discounts Buy Now from Amazon just by
Clicking This Image

Simply send snap of your product details after delivery at ad22092012@gmail.com for more surprises or additional discounts