File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
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
Author

SQL ServerAgent restarting automatically

jay donald
Greenhorn

Joined: Feb 09, 2006
Posts: 20
HI,
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.

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

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?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: SQL ServerAgent restarting automatically