Results 1 to 9 of 9
  1. #1
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Unanswered: SQL Server Agent Service issues...

    Here is an odd one:

    I switched my SQLSERVERAGENT service to use the Local System Account.

    I stopped and restarted the service.

    Both the Services window and Enterprise Manager show the SQL Server Agent is running. But when I try kicking off a job I get the following message:
    Code:
    Error 22022: SQLServerAgent is not currently running so it cannot be notified of this action.
    Any clues as to why the agent could be running, but not know that it is running?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    is it truly running? what does service control manager say?

    is there anything useful in agent's log file (SQLAGENT.OUT)?

    also this might help:

    http://support.microsoft.com/kb/911841

  3. #3
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    I would definitly go into admin tools and take a look at services. is it a production box? can you pull a fonzi with no one noticing?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    The agent is truly running, according to both the Windows Services manager and SQLServer Enterprise Manager.

    I can't pull a Fonzi because I don't have physical access to the box. It is up in Canada. Maybe I could get Rudy to do it for me....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1

    Even stranger...!

    Wow, this is odd.

    My jobs are still running!
    I've got an auditing job that runs every five minutes, and it has executed without error since yesterday. But when I try to kick it off manually I still get the message that the agent isn't running!
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Mar 2005
    Location
    Netherlands
    Posts
    280
    Are you trying to kick off the job in EM? Have you tried sp_start_job from QA?

    I know EM has some problems with refreshing so maybe it still thinks the agent is stopped. It doesn't look like a SQL Server error so mayby it's one from EM itself.

  7. #7
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Good suggestion, so I tried it. But it also give me the error:
    Code:
    Server: Msg 22022, Level 16, State 1, Line 0
    SQLServerAgent is not currently running so it cannot be notified of this action.
    ...and yet my jobs have gone on merrily executing since yesterday....
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  8. #8
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    is this a virtual machine?
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  9. #9
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    or part of a cluster perhaps?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •