Posted by Erland Sommarskog on 06/10/05 00:14

(wamatt@gmail.com) writes:
> Subject: SQL server job timeouts?
>
> We have a job that uses WinHTTP inside a stored procedure. We have
> another SP wrapper that runs this for a couple hundred records.
>
> When we add this as a job using SQLAgent it times out half way. Running
> it from SQL Query analyser and it completes to the end.
>
> Anyway to set the timeouts for jobs?

Exactly which component bitches about the timeout? It should not really
be SQL Server Agent, as a job could run for a long time. WinHTTP is a
complete unknown to me.

Could you explain the exact message you get? Don't forget to expand Job
History, and look at the output from the individual job steps.

One possible workaround, is that you can set up a retry interval and a
retry count for the job step, so if fails half-way, it could get a
second change to do the rest.

--
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

[Back to original message]