Bulk Scheduling Of WEBI Docs (XIR3)

I have a requirement to group WEBI docs by order of priority and then schedule them to run in that priority i.e. 100 reports need to be scheduled to run but must run a specific 50 first and then the other 50.

I know that you could use publishing or packaging to obtain a similar result but the client wants to view the results as instances on the original docs.

Any ideas?


jrc@maxima (BOB member since 2010-02-05)

Set the schedule time such that the second set of reports run after the completion of the first set of reports.


Raj_admin :india: (BOB member since 2008-12-04)

You could use an event to trigger the second set on completion of the first set…


Mak 1 :uk: (BOB member since 2005-01-06)

Sorry I should have been clearer. The reports need to be scheduled to run over night, after a data load has completed, so that they are ready for users to view in the morning (I am using a file based event to achieve this). However, the data load could finish at any time, this means that I can not simply schedule the second set of reports to run at a later time than the first set as I do not know when the first set will run or finish. What I really need to be able to do is run the first set of reports once the file based event has been triggered and then run the second set once the first set has finished running. The only way I can see to currently achieve this is to link every single report using events (so that a report is waiting for an event which another report will trigger upon completion) but in the actual scenario there are hundreds of reports so this would be too difficult to maintain. What I would really like to be able to do is use the same event based method but on a group of reports rather than a single one.

Hope that makes more sense now…


jrc@maxima (BOB member since 2010-02-05)

You would probably need to use a 3rd Part Add-On tool like APOS Instance Manager or InfoScheduler to manage those Event Links.

We use a bunch of their tools to supplement the limits of CMC and InfoView.


MJRBIM :canada: (BOB member since 2007-03-23)

Mr Bim,

Thanks for the update. I couldn’t, for the life of me, think of a way of achieving this out of the box… :slight_smile: .

Cheers,

Mark.


Mak 1 :uk: (BOB member since 2005-01-06)

thanks I’ll look into the 3rd party tools…


jrc@maxima (BOB member since 2010-02-05)