1

I am using SQL server 2014.

I notice that - occasionally, the sql server agent service gets automatically stopped.

Where can I find logs to check the timing of when the service stop has happened and what has caused the service to stop?

Note: I am not asking for agent job logs. I want the agent service logs.

Improve this question

1 Answer 1

Reset to default
3

In Object Explorer, there is a folder at the bottom called Error Logs, you can see them in there. Right clicking on the folder and choosing Configure will show you where they're stored, and what things are being tracked.

enter image description here

Improve this answer
2
  • This log holds the job related logs. Does this have the sql agent service logs?
    – variable
    Commented Aug 16, 2021 at 18:20
  • Yes, you will see a stop message if the service stops. Try it out in a dev instance, stop the the agent, then start the agent. You should see the stop message in the 2nd latest log file, not the current one. You can also query it with xp_readerrorlog. Current agent error log: EXEC xp_ReadErrorLog 0,2 Previous one: EXEC xp_ReadErrorLog 1,2
    – BCM
    Commented Aug 16, 2021 at 19:11

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.