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

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

Gudddu
Starting Member

India
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
SIReport
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.

visakh16
Very Important crosS Applying yaK Herder

India
52309 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
http://visakhm.blogspot.com/

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.06 seconds. Powered By: Snitz Forums 2000