wood burning stoves 2.0*
The moose likes JDBC and the fly likes SQL ServerAgent restarting automatically Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
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?
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
subject: SQL ServerAgent restarting automatically
Similar Threads
Webservices using hibernate, jboss and eclipse and MySQL
Issue with JAVA_HOME setup
WS 4 in Window NT Problem
Database Access works on a manually started Tomcat but not on a Tomcat started as a Service
entire msg