Re: Need more information about SQL job that fails
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.
"Dan DeCoursey" <[email protected]> wrote in message
hi I have a string of jobs that execute in sequence. From time to time I
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
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
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
the covers as this job starts up and / or a wya to get some sort of
alarm/alert/notification that the server is hosed