Is there anything like time out for a SQL Agent JOB. How long a SQL
Agent Job can run ?

If you are talking about Job duration ("How long a SQL Agent Job can
run") -it executes until it completes. If you want it to terminate before it
completes, then you will have to create another Job that checks to see if
the first Job is still running, and if so, then terminates it -using
sp_stop_job.

If you are concerned about resource timeouts, network access, drive
availability, server availability, I believe that timeouts waiting for those
resources varies from immediate to 30-60 seconds.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous


"ArchieM" <mukherjee.archan (AT) gmail (DOT) com> wrote