Geek asks and answers

How to install SQL Server 2005 Job CmdExec Timeout

I have a job setup in SQL Server 2005 with an operating system step (CmdExec).

This step calls up a program that can take a long time. I see that if the program needs more than 1 minute 40 seconds to respond, the step fails with the error message "Operation Validity Period". The program actually continues to work and generates the desired results.

How to set a waiting period for a step in this task. Alternatively, if there is a way to set a timeout for the entire job, which would be just as useful as this is the only step in the job. If all else fails, I would like to change the timeout for the entire server, although obviously this would be the last resort.

I tried to examine the properties for the step, job, and SQL Server agent, but could not find anywhere to set this parameter.

+2
source share
2 answers

SQL jobs do not have timeouts — you cannot configure them yourself if they run too long or reach a specific point in time. (If you could!), You can configure the steps to check the time or duration, and you can program the steps taken in the steps to check the time, but there is no step on the task or level.

, . -? , , , SQL , " ", cmdexec. , , ( - ). ? , , , - - .

+2

- - . , SQL Server.

, , , - . , , , , - , - .

-, .

+1

More articles:


All Articles