Does SQL Server job wait to finish the currently executing call before starting the next schedule call?

Asked May 27 '13 at 06:15

Active May 27 '13 at 06:30

Viewed 71 times

I have created a sql server job which runs a stored procedure. I have scheduled this job to run at every 10 seconds.

Now my question is, If a job is running and it takes more than 10seconds (lets say it takes 20sec), is there a chance that sql job will start the next schedule?

edited May 27 '13 at 06:30

Andrew Barber

39,603
20
94
123

asked May 27 '13 at 06:15

AnandPhadke

13,160
5
26
33

1

One option would be to put your processing logic in a thread safe "service agent" model if it is mission critical. Via MSSQL you lose control over thread assignments. – Ross Bush May 27 '13 at 06:24
@AnandPhadke - I believe the linked question adequate to answer yours. If I'm wrong, I have misinterpreted your question. – Lieven Keersmaekers May 27 '13 at 06:29
@ LievenKeersmaekers -- Its exactly waht I am looking for.Thanks – AnandPhadke May 27 '13 at 06:29
1

@AnandPhadke - I was going to comment that I would expect the jobscheduler to just start a new job nonetheless. I would have been very wrong :). – Lieven Keersmaekers May 27 '13 at 06:30

Does SQL Server job wait to finish the currently executing call before starting the next schedule call?

0 Answers0