JOb Scheduling

Question

Post reply

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: 245813 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.

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

Koen Verbeeck SSC Guru Points: 259015 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://qa.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: 245813 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://qa.sqlservercentral.com/Forums/Topic1586306-2799-1.aspx

Grrr!:angry:

If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.