Post reply

SQL Server Agent State= change pending.

  • August 14, 2011 at 4:56 am

    #390190

    Hi Folks,

    On one of my Database SQL server Agent State is Change Pending..

    Kindly help me anyone regarding to fix this issue..

    TIA...

  • August 14, 2011 at 8:41 am

    #1368387

    When was the sql Restarted last time?

  • August 15, 2011 at 1:39 am

    #1368465

    Have you installed a CU/SP? Has anything changed with the service account or where the agent logs are written to?

    Have you tried simply restarting the service?

    _________________________________________________________________________________SQLGeordieWeb:- Jarrin ConsultancyBlog:- www.chrisjarrintaylor.co.ukTwitter:- @SQLGeordie

  • August 15, 2011 at 3:19 am

    #1368482

    Restarting sql services will resolve the issue. But you need to find out, why it went change pending state.

    If you can briefs us the activities performed, it will help us understand that.

  • August 15, 2011 at 10:53 pm

    #1368928

    Thanks for your replies,

    I've fixed this issue by rebooting Windows server..

  • July 12, 2013 at 2:24 am

    #1631843

    In our case someone removed the dll files on the binn directory. So we had to restore the dll files from the point in time when sql was up and running. we manage to sart the sql server.:w00t:

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply