[Top] [All Lists]

Need more information about SQL job that fails

Subject: Need more information about SQL job that fails
From: Dan DeCoursey
Date: Thu, 25 Jun 2009 06:05:01 -0700
Newsgroups: microsoft.public.sqlserver.notificationsvcs
hi I have a string of jobs that execute in sequence. From time to time I will 
find my SQL server  unresopnsive. Screen saver frozen,  no reponse with 
I have been forced to use power button to restart the server.

No pattern as to when or why.......except  its the same job at the very same 
time of day (10:32pm)

I could get 2 of these  "hose ups" in one week  but then not get one for 2 
months..... but upon examining the event logs we see the same job started and 
the meassage in the morning   after we re boot ....  "enexpected shutaown 
yesterday at 10:32pm"

I am exploring if there is a way to gain more info on whats happening under 
the covers as this job starts up   and / or a wya to get some sort of 
alarm/alert/notification  that the server is hosed

<Prev in Thread] Current Thread [Next in Thread>