This week's book giveaway is in the Big Data forum.
We're giving away four copies of Elasticsearch in Action and have Radu Gheorghe & Matthew Lee Hinman on-line!
See this thread for details.
The moose likes JDBC and Relational Databases and the fly likes SQL ServerAgent restarting automatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Elasticsearch in Action this week in the Big Data forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQL ServerAgent restarting automatically" Watch "SQL ServerAgent restarting automatically" New topic

SQL ServerAgent restarting automatically

jay donald

Joined: Feb 09, 2006
Posts: 20
Our main internal application has been dying for last month at the same day on the same day. Looking at everything, We noticed SQl Server Agent was restarting at that time for no apparent reason. This is what we get:

Does anyone know why it's restarting automatically or point me to the link where i can learn more. I would appreciate any help i get. Thanks for your time.

Note: i read somehwere to check if SQl Server is running on "light weight pooling mode". Could someone please tell me how to check that.

[ April 21, 2006: Message edited by: jay donald ]
jay donald

Joined: Feb 09, 2006
Posts: 20
I didn't want to edit the post again! I have checked and it's running on thread mode processing. Could this be it?
subject: SQL ServerAgent restarting automatically