In this example, the job is allowed 3 minutes of execution time.
Each step is allowed 2 minutes of execution time. Should either
step try to execute beyond 2 minutes, the job will terminate
beginning with that step. If STEP1 executes in 1.74 minutes and
if STEP2 tries to execute beyond 1.26 minutes, the job will be
terminated because of the 3-minute time limit specified on the
My doubt is that how is this possible when
EXEC - TIME will override JOB - TIME .
So, in this case both the steps should be executed regardless of the job time.
STEP1 can use the processor for 25 seconds. If STEP1 actually uses the processor for only 15 seconds, the time limit for STEP2 is the smaller of the following values:
> The job time remaining (35 seconds)
> The time limit specified on the EXEC statement for STEP2 (40 seconds).
In this case, the job time remaining is the smaller value, so STEP2 can use the processor for 35 seconds. If STEP2, then, actually uses the processor for only 30 seconds, STEP3 can use the processor for 5 seconds, because that is the time remaining from the previous step.