|
We are unable to start SQL Server Agent. It was giving the following error when we were trying to start it from the services console The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped. Some services stop automatically if they have no work to do, for example, the...
(comments are locked)
|
|
As well as checking the windows event logs, also look at the SQLAgent error logs - they're just text files, located (usually) in the LOG directory of your SQL Server installation. You're looking for a file named "SQLAgent.OUT", "SQLAgent.1" etc.
(comments are locked)
|
|
Sometimes I've seen an issue where the Agent can't start as there are locks on the previous log files, and it can't rollover the file names - and it therefore can't log why it can't start either! In that case a server reboot has been necessary, but I appreciate that that isn't always possible.
(comments are locked)
|
Have you checked the Event Logs?