Posted by Erland Sommarskog on 10/01/37 11:20

(wamatt@gmail.com) writes:
> Ok however its not actually the WinHTTP that times out - its the stored
> procedure wrapper itself.
>
> The wrapper is as follows as you can see it calls "EXEC
> SFIN_Bill_Client_CC @Code" that inner SP contains the WinHTTP call.
> It might run through 50 records or so before the wrapper times out.
>
> This only happens when its called via SQL job. Using query analyser it
> works fine.

Well, did you try again, and this time saved the complete error message
from the Step Details in the job history? It would help to see it.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

• Next in forum: Re: Backup on network!
• Prev in forum: Re: T-SQL create self-reference in depending table
• Thread view: Re: SQL server job timeouts?

[Reply to this message]