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

Bug #: 474786 (SQL Server 8.0)

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

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 ObjectName registry entry under the following registry subkey. For a default instance, the registry subkey is as follows:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER\
For a named instance, the registry subkey is as follows:
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQL$InstanceName\
Note InstanceName is a placeholder for the instance of SQL Server.

Resolution

Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756 How to back up and restore the registry in Windows


To resolve this problem, modify the registry entry that is mentioned in the "Cause" 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 "Applies to" section.
Propriedades

ID do Artigo: 911841 - Última Revisão: 16 de jun de 2008 - Revisão: 1

Comentários