Microsoft KB Archive/911841

= You may receive an &quot;Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action&quot; error message when you run a SQL Server Agent job in SQL Server 2000 =

Article ID: 911841

Article Last Modified on 11/2/2007

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 2000 Developer Edition
 * Microsoft SQL Server 2000 Enterprise Edition
 * Microsoft SQL Server 2000 Personal Edition

-



Bug #: 474786 (SQL Server 8.0)



Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows registry



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

Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action.&quot;



CAUSE
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.

If the SQL Server Agent service is running, this problem occurs because the SQL Server Agent service cannot interpret the dot mark (.) that represents the local computer in the  registry entry under the following registry subkey. For a default instance, the registry subkey is as follows:

For a named instance, the registry subkey is as follows:

Note  is a placeholder for the instance of SQL Server.



RESOLUTION
Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To resolve this problem, modify the registry entry that is mentioned in the &quot;Cause&quot; section by replacing the dot mark with the computer name.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

Keywords: kbexpertiseadvanced kbsql2005engine kbprb KB911841

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.