microsoft.public.sqlserver.notificationsvcs
[Top] [All Lists]

Re: Need more information about SQL job that fails

Subject: Re: Need more information about SQL job that fails
From: "Russell Fields"
Date: Tue, 30 Jun 2009 17:00:28 -0400
Newsgroups: microsoft.public.sqlserver.notificationsvcs
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" <[email protected]> wrote in message news:[email protected]
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

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