Event based Job - event occurs while job is running
660489Oct 15 2008 — edited Dec 23 2008I noticed this in the Event Scheduler documentation:
"The Scheduler runs the event-based job for each occurrence of an event that matches event_condition. However, events that occur while the job is already running are ignored; the event gets consumed, but does not trigger another run of the job"
I have a case where a job is being triggered by the insert of a row into a table. I need a way to trigger the job again if a 2nd row is inserted while the first instance of the job is running. Any ideas or can you direct me to any threads? I figured my 2 options would be 1) have the trigger check if the job is running and if so, wait until it is finished to post the event to the queue (I don't think this is very good) or 2) have the job select from the table at the end of it's processing to see if there are any more rows to process.
Any other options?
Paul.