Issue with SQL Agent job

• gary1

  SSC-Insane

  Points: 21152

  More actions

  July 30, 2010 at 12:17 pm

  #157118

  Hi,

  We have SQL Server 2005 EE x64 with SP3.

  We have SQL agent job, an ETL job, and it's running successfully but the job history has the following error message.It's happening for sometime, like 30 mins and after that the job is running fine.

  Message

  Executed as user: abc\mssqlsrv. ...t_ISLLSYS_20010101.asp?policyid=1234&userid=spal [SQLSTATE 01000] (Message 0) Source = msxml6.dll, Description = The server name or address could not be resolved [SQLSTATE 01000] (Message 0) http://App/abc.App.client/system/asp/ETL1.asp?policyid=1234&userid=spal [SQLSTATE 01000] (Message 0) Source = msxml6.dll, Description = The server name or address could not be resolved [SQLSTATE 01000] (Message 0)

  We have two application server App1 & App2 and they load balanced and its name App. When I see this message in Job history, then the users NOT able to some functionality in the application.

  Based on above job message, what could be the cause? Is it SQL Server issue or Application issue?

  Please give me your inputs

  Thanks

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  July 30, 2010 at 1:42 pm

  #1200531

  Description = The server name or address could not be resolved

  From the error message it does not look like an issue with SQL Server. Check the server which is being called in the job is accessible

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga