,Unable to start sql server agent from sql server configuration manager

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...
more ▼

asked Sep 07 '12 at 05:50 AM in Default

samapti gravatar image

10 1 1 1

Have you checked the Event Logs?
Sep 07 '12 at 07:39 AM sp_lock
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first
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.
more ▼

answered Sep 07 '12 at 07:48 AM

ThomasRushton gravatar image

ThomasRushton ♦
33.4k 14 20 44

(comments are locked)
10|1200 characters needed characters left

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.
more ▼

answered Sep 07 '12 at 09:20 AM

Kev Riley gravatar image

Kev Riley ♦♦
50.8k 44 49 76

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Sep 07 '12 at 05:50 AM

Seen: 1008 times

Last Updated: Sep 07 '12 at 09:20 AM