Need more information about SQL job that fails
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