RSS

Error 22022 SQL Server Agent not running

14 Oct

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

 

 
10 Comments

Posted by on October 14, 2011 in Errors

 

10 responses to “Error 22022 SQL Server Agent not running

  1. Anbarasan.C

    June 3, 2014 at 9:29 PM

    Now its working fine..thanks…

     
  2. shivam

    June 11, 2014 at 5:22 AM

    thanks man…

     
  3. eric

    April 9, 2015 at 3:47 PM

    thanks dude.!

     
  4. Arsalan Khan

    May 19, 2015 at 3:51 AM

    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?

     
  5. Arvind Gupta

    May 19, 2015 at 4:21 PM

    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??

     
  6. short url

    May 29, 2015 at 12:39 PM

    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.

     
    • Mustafa EL-Masry

      May 29, 2015 at 6:09 PM

      Many thanks for your nice words , welcome in my community keep following me to know the new feature in SQL SERVER. 2016

       

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s