0

Our SQL Agent server stopped working suddenly. We checked services and found that it got stuck in "Starting" status. We tried to restart by right click option but all start, stop and restart options are disabled (displaying grey). We checked Sql Agent server logs.

SQLAgent.OUT has following :

SQLSERVERAGENT service stopping due to a stop request from a user, process, or the OS... Scheduler engine timed out (after 15 seconds) waiting for 80 jobs to stop SQLServerAgent terminated (forcefully)

So please help us what should we do except rebooting the machine (We want to avoid reboot machine as it's production server).

pirho
  • 11,565
  • 12
  • 43
  • 70
Rama Shankar
  • 103
  • 2
  • 10
  • Do you see a sqlagent.exe process? Maybe try to kill it, start again and check the logs. – kirchner Feb 01 '18 at 18:27
  • kill the `sqlagent.exe` in the task manager and start the agent again – Krismorte Feb 01 '18 at 18:41
  • Thanks Kirchner & Krismorte, there is no sqlagent.exe in the task manager. I think that comes in the task manager when our service is running but that's not the case at my end. Sql Agent server got stuck into "Starting" status. I can see SQLAGENT$SERVERNAME in Services tab of task manager when i click on "Go to Details" of this services, it takes me to "System Idle process" of processes tab.End task is disabled for this process so we can't kill this. – Rama Shankar Feb 02 '18 at 05:20

0 Answers0