Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQLServerJob failing Expand / Collapse
Author
Message
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: Wednesday, September 3, 2014 1:16 AM
Points: 2, Visits: 159
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: 2 days ago @ 8:53 AM
Points: 102, Visits: 1,072
See the another thread having resolution..
http://www.sqlservercentral.com/Forums/Topic1030483-146-1.aspx


Regards,
Kumar
Post #1401766
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse