SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
Register Now and get your question answered!
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

1 Posts

Posted - 01/31/2012 :  22:23:04  Show Profile  Reply with Quote
Hi All.....How are you?

I am very new to SQL Server and I must say that your blog has helped me a lot in the past.

I am struggling with a problem and may be you could help me a little.

I have a problem whereby the JOBS Scheduled in SQLServer are failing with the error as below

Executed as user: SmartInfoApplication. error executing method [SQLSTATE 01000] (Message 0) SIReport [SQLSTATE 01000] (Message 0) The remote server machine does not exist or is unavailable [SQLSTATE 01000] (Message 0) Error Running Report [SQLSTATE 42000] (Error 50000). The step failed.

The version of SQLSERVER is

Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18:38 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2)

The job definition is in the attached file......The first step of the job is a Transact SQL which is as follows

exec csp_CR_Run 2706883

The definition of SP is in the attached file and also on the link http://pastebin.com/kyeYW7RZ

When i run the step SQL Code manually in Query analyzer, i get this

error executing method
The remote server machine does not exist or is unavailable
Server: Msg 50000, Level 18, State 1, Line 3
Error Running Report

At times, i even get the error permission denied but interestingly the error disappears after a while.

Even this error that I indicated above is seen only intermittently and does not happen always. We are at a loss in trying to troubleshoot this as the behavior is quite random.

Appreciate if you could guide me with this one.

Very Important crosS Applying yaK Herder

52326 Posts

Posted - 02/01/2012 :  09:55:13  Show Profile  Reply with Quote
does query use a remote linked server connection? first check and see if connection is active and table/data is accesible

SQL Server MVP

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000