Re: SQL Agent Job fails intermittently

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Paritosh Pathak (ppathak_at_litton.c-bass.com)
Date: 04/22/04 

Date: Thu, 22 Apr 2004 10:44:59 -0500

Hi Dirc

Are you running DBCC Reindex while logged on locally at the server? This
error seems to be network related

-Paritosh
"Dirc Khan-Evans" <dirc.khan-evans@eqos.com> wrote in message
news:OdbbddHKEHA.2624@TK2MSFTNGP09.phx.gbl...
> A job which reuns a DBCC REINDEX on a largish table (~6 million rows) with
a
> clustered index and another index, fails intermittently with the following
> details:
>
> ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054)
> General network error. Check your network documentation. [SQLSTATE 08S01]
> (Error 11). The step failed.
>
> This can sometimes error out after 15 mins or after an hour and does not
> occurr every time, say once or twice a week.
>
> Has anyone come across this? Can't find any info as to what is happening.
> This is the only thing that is happening on the system at the time as far
as
> we can see.]
>
> so, what does this fantastic error message imply?
>
> Ta
>
> Dirc
>
>
>
>