Optimization job failing

9 May 2005 5:49 PM

Orn

I have scheduled the optimization job to run everyday and sometimes it fails.
I get this:

Executed as user: test\test. ConnectionCheckForData (CheckforData()).
{SQLSTATE 01000} (Message 10054) General network error. Check your network
documentation. {SQLSTATE 08S01} (Error 11). The step failed.

It does not fail every night. I had it scheduled to run once a week, but it
was taken a long time to run so I thought I would run it more often to reduce
the time.

Also, I notice that when the optimization job is running the transaction log
backup fails.

Any help would be greatly appreciated.

Thank you!

9 May 2005 9:16 PM

Donna Lambert

Are you having network problems sporadically? Run ping -t all night several
nights in a row (dump to a text file) and see if you have any 'blips" in
connectivity.

Show quoteHide quote

"Orn" wrote:

> I have scheduled the optimization job to run everyday and sometimes it fails.
> I get this:
>
> Executed as user: test\test. ConnectionCheckForData (CheckforData()).
> {SQLSTATE 01000} (Message 10054) General network error. Check your network
> documentation. {SQLSTATE 08S01} (Error 11). The step failed.
>
> It does not fail every night. I had it scheduled to run once a week, but it
> was taken a long time to run so I thought I would run it more often to reduce
> the time.
>
> Also, I notice that when the optimization job is running the transaction log
> backup fails.
>
> Any help would be greatly appreciated.
>
> Thank you!

10 May 2005 2:50 PM

Orn

ok, i will try that.

Can you tell me what the network would have to do with an optimization job
running locally on the SQL server?

Thank you.

Show quoteHide quote

"Donna Lambert" wrote:

> Are you having network problems sporadically? Run ping -t all night several
> nights in a row (dump to a text file) and see if you have any 'blips" in
> connectivity.
>
>
> "Orn" wrote:
>
> > I have scheduled the optimization job to run everyday and sometimes it fails.
> > I get this:
> >
> > Executed as user: test\test. ConnectionCheckForData (CheckforData()).
> > {SQLSTATE 01000} (Message 10054) General network error. Check your network
> > documentation. {SQLSTATE 08S01} (Error 11). The step failed.
> >
> > It does not fail every night. I had it scheduled to run once a week, but it
> > was taken a long time to run so I thought I would run it more often to reduce
> > the time.
> >
> > Also, I notice that when the optimization job is running the transaction log
> > backup fails.
> >
> > Any help would be greatly appreciated.
> >
> > Thank you!