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

 

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/

12 thoughts on “Error 22022 SQL Server Agent not running”

  3. Pingback: Fix Sql Agent Error 22022 Windows XP, Vista, 7, 8 [Solved]

  5. Shabab Motafa.. i have a Q…
    i had tried all of the above and that is what every website talk about. My environment is 2 node clustered with 1 sql 08r2 instance.

    Initially i had the following error:
    SQL Server blocked access to procedure ‘sys.xp_sqlagent_enum_jobs’ of component ‘Agent XPs’ because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of ‘Agent XPs’ by using sp_configure. For more information about enabling ‘Agent XPs’, see “Surface Area Configuration” in SQL Server Books Online

    did the following:
    EXEC sp_configure ‘show advanced’, 1;
    RECONFIGURE;
    EXEC sp_configure ‘allow updates’, 0;
    RECONFIGURE;
    EXEC sp_configure ‘Agent XPs’, 1;
    RECONFIGURE;
    GO

    Checked the status of agent it was stopped
    started via cluster manager and it failed to start. There was no error being produced in sql error logs. There was no SQLAGENT*.* produced either.

    I ensure that the account under which the agent is running has permissions on the folder level. and it did exist.

    I could see all my jobs with the above tsql BUT when i started any job i would get Error 22022 SQL Server Agent not running

    On changing the following parameter from No to YES brought my services online SQLServerAgent–>Properties–>Advanced–>ErrorReporting

    would you have any explanation for this?

    Like

    Reply

  6. Hiii.. i m Doing Data Replication in SQL server 2005. While subscription i have completed steps and finally i am running my script named ‘LCDBARCODE-dbmodelmaster-Merge Test-DATABASEFILESER-2’ (in my case). it throws the error you mentioned above and i used the solution u given above, it works, But again i m running the script its started the process, but its not coming end, its continuously running, Can u suggest me on this something??

    Like

    Reply

  7. Just want to say your artucle iss as astounding.
    The clarity in your publish is just excellent
    and i could think youu aare a professional in this subject.
    Finee with your permission let me to snatch your RSS feed to stay updated with coming near near post.
    Thnk you one million and please carry on the gratifying work.

    Liked by 1 person

    Reply
  8. Pingback: Error Number 22022

Leave a comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.