Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

SQLServerJob failing Expand / Collapse
Posted Thursday, August 9, 2012 2:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Sunday, February 7, 2016 7:17 AM
Points: 2, Visits: 177
I have a job that executes fine most of the time but sometimes it fails with the error below. The service for SQLServerAgent is logging on with a windows account and the job is owned by sa. The job has one step executing a maintanenceplan with the following code EXECUTE master.dbo.xp_sqlmaint N'-PlanID 80CB4BBB-AF15-4C7E-AD3B-02CCA9B6F85B -To "Remote DBA" -WriteHistory -BkUpMedia DISK -BkUpLog "Folderpath" -DelBkUps 3DAYS -BkExt "TRN"'

The view history for the job shows the error:
Executed as user: DOMAIN\user. ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed.

The log for SQLServerAgent shows two errors:

1. [382] Logon to server 'SERVERNAME' failed (ConnAttemptCachableOp)
2. [165] ODBC Error: 0, Timeout expired [SQLSTATE HYT00]

The output from select @@version is:
Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

We have 3 servers one with SQL Server 2005 and two with 2000. The same error occurs in the SQLServerAgent log on all the servers but are very rare on two.
Post #1342463
Posted Wednesday, January 2, 2013 4:32 AM


Group: General Forum Members
Last Login: Tuesday, November 15, 2016 3:41 AM
Points: 103, Visits: 1,267
See the another thread having resolution..

Post #1401766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse