Prioritizing Event Driven Rpts

scheduling XI Scheduler
1

Question:
I have two Reports (Rpt A, and Rpt B), both are scheduled with the same File based Event/Trigger. However, “Rpt A” schedule starttime is 12:30, and “Rpt B” Schedule Starttime is 12:35.

With the above in mind, I thought I understood that the BO Scheduler basically uses a FIFO approach (ie. First In/First Out). Which I believe should mean that when the Event/Trigger gets fired, “Rpt A” should ALWAYS start running before “Rpt B”. Isn’t this correct??

I’m wondering if my version of BO may have a Scheduling bug, because this is NOT always happening (ie. sometimes “Rpt B” will start running BEFORE “Rpt A”).

We are on BOXI 3.1 SP3 (Windows)…

Thanks!!

Captspeed :us: (BOB member since 2006-10-03)

2

BOE does not use a FIFO approach when it comes to event based scheduling. The scheduled start time tells the job when to start looking for the event. Once it is triggered, jobs can run in any order.

BoB LoblaW :us: (BOB member since 2007-10-23)

3

…if you wanted Report A to always run before Report B, use the File based event to Trigger Report A, and then execute a Schedule Based event to trigger Report B.

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

4

thx mcnelson, but don’t think that would work. As Report B must also be triggered on the same event (file based) as Report A. I just want Report A to start running BEFORE Report B…

Captspeed :us: (BOB member since 2006-10-03)

5

Why does it need to run before? I assume, as they can run concurrently, that it’s not a data dependency issue - is it more of a synchronization issue?

HTH

NMG

mcnelson :uk: (BOB member since 2008-10-09)

6

Its actually an SLA issue. We want to ensure that our reports with an SLA run & complete successfully BEFORE the SLA promised time.

Captspeed :us: (BOB member since 2006-10-03)