SQL Agent

Question

SQL Agent

sudhakara

SSCrazy Eights

Points: 9425
More actions
August 29, 2009 at 3:11 pm

#210138

Hi..
when i try stop sql server agent job its giving the following error message "SQLServerAgent Error: Request to stop job logspaceutilise (from User sa) refused because the job is not currently running." but its running without any error message. i have tried to stop from management studio and sp_stop_job, but both method giving the same error message.
Sql Edition : SQL Standard 2005
SP : SP3
os : windows 2003
Thanks in Advance.

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

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

PaulB-TheOneAndOnly SSC Guru Points: 66772 More actions · Answer 1

In general I would trust SQL Server and say "job is not running" but if you are certain the job is executing... kill the session 😉

_____________________________________
Pablo (Paul) Berzukov

Author of Understanding Database Administration available at Amazon and other bookstores.

Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 2

thks for your reply...

i have one more question.i want send mail if sql server agent is not running .how do i find status of sql agent ?

Thanks in advance.

ankur_libra Hall of Fame Points: 3999 More actions · Answer 3

Hi Sudhakara,

Please check following link for your questions's answer, provided by me:

http://www.sqlservercentral.com/Forums/Topic735557-145-1.aspx

Ankur 😛

ankur_libra Hall of Fame Points: 3999 More actions · Answer 4

Hi Sudhakara,

For Checking SQL Agent status, you can use:

xp_servicecontrol querystate, MSSQLAgent

Ankur:-D

sudhakara SSCrazy Eights Points: 9425 More actions · Answer 5

ankur_libra (8/31/2009)
Hi Sudhakara,
For Checking SQL Agent status, you can use:
xp_servicecontrol querystate, MSSQLAgent
Ankur:-D

Hi Ankur,

thanks for your reply ...

while running this query in sql server 2008 its showing result as running but sql server agent was not running.

can you tell me the how do i find the sql server agent status ?