JOb Scheduling

Question

JOb Scheduling

greeshatu

Right there with Babe

Points: 791
More actions
June 26, 2014 at 3:08 am

#290345

HI
I have a job which runs every two minutes.
I need to schedule it in such a way that until first run finishes second run should no be invoked.
[i,e] For eg: If run1 taking more than 2 minutes to complete ,Run2 should be invoked only after run1 is done.
Please help

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Phil Parkin SSC Guru Points: 246962 More actions · Answer 1

If you're using a SQL Agent job, you should have nothing to worry about. If the job is still running after two minutes, it will not be invoked again until the next scheduled occurrence two minutes later.

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin

Koen Verbeeck SSC Guru Points: 259105 More actions · Answer 2

Please do not crosspost. It wastes peoples time and fragments replies (like Phil Parkin).

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1586306-2799-1.aspx

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Phil Parkin SSC Guru Points: 246962 More actions · Answer 3

Koen Verbeeck (6/26/2014)
Please do not crosspost. It wastes peoples time and fragments replies (like Phil Parkin).
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1586306-2799-1.aspx

Grrr!:angry:

The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin