Need more information about SQL job that fails

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dan DeCoursey - 25 Jun 2009 14:05 GMT

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

Reply to this Message

Russell Fields - 30 Jun 2009 22:00 GMT

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

> hi I have a string of jobs that execute in sequence. From time to time I
> will
[quoted text clipped - 16 lines]
> the covers as this job starts up and / or a wya to get some sort of
> alarm/alert/notification that the server is hosed

Reply to this Message