«

»

Aug 31

ERROR: 22022 SQL Server Agent not running

When you run a SQL Server Agent job in Microsoft SQL Server 2008, you may receive the following error message:

……………………………………………………………………………………………………………………………………………………………………………….
 Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action.”
 If you receive this error message, first make sure that the SQL Server Agent service is running. To do this, follow these steps:
……………………………………………………………………………………………………………………………………………………………………………….
1.Click Start, click Run, type Services.msc, and then click OK.

2.In the Services window, locate the SQL Server Agent service.
3.Make sure that the value of the Status column of the SQL Server Agent service is Running.
then
EXEC sp_configure ‘show advanced’, 1;
RECONFIGURE;
EXEC sp_configure ‘allow updates’, 0;
RECONFIGURE;
EXEC sp_configure ‘Agent XPs’, 1;
RECONFIGURE;
GO

Incase still you are getting the same error message while executinng the configured job in SQL Agent than check the MSDB recovery state If the databse recovery is pending than wait for some time once the MSDB recovery completed than you will not receive the “ERROR: 22022 SQL Server Agent not running”.

 

Note: Check the SQLAGENT.OUT log file you can find the message Error: (362) Database recovery is runnig.