August 9, 2012 at 2:55 am
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.
January 2, 2013 at 4:32 am
See the another thread having resolution..
http://qa.sqlservercentral.com/Forums/Topic1030483-146-1.aspx
Regards,
Kumar
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply