Need more information about SQL job that fails

[Dan DeCoursey]

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
keyboard/mouse.
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

[Russell Fields]

Dan,

Have you checked for dumps being recorded on your SQL Server? If an
exception is being registered, it is possible that at least some data got
recorded. Look in the same directory where the SQL Server logs are written.
(Not database log files, but the "application" log of SQL Server.)

If there is anything there it might give you a clue. Unless, of course, the
hang is so hard that there is no time to write anything out to disk.

By the way, microsoft.public.sqlserver.server is probably the better place
to ask this type of question. More people monitor that group.

FWIW,
RLF

"Dan DeCoursey" <DanDeC...@discussions.microsoft.com> wrote in message
news:352AAD45-3E53-492B...@microsoft.com...