Timeline for Where can I find sql server agent service logs?
Current License: CC BY-SA 4.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Aug 16, 2021 at 19:11 | comment | added | BCM | 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 | |
| Aug 16, 2021 at 18:20 | comment | added | variable | This log holds the job related logs. Does this have the sql agent service logs? | |
| Aug 16, 2021 at 13:30 | history | answered | BCM | CC BY-SA 4.0 |