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