Report scheduling priorities? 1

[OldSkoolSkater]

Are you able to asign a priority to scheduled reports in CE10?
If there are for example 50 reports set to run at the same time I want to be able to run certain reports first as they are most important.

Cheers

Steve - Network Coordinating in the UK

 

[martinjbailey]

Steve

Would scheduling your reports based on event (file or custom) driven triggers suffice ? This would work if it were the same reports you wanted to run first each time.

Martin

 

[OldSkoolSkater]

We will be moving to CE10 shortly from SI7.5

Our current problem is that virtually all of our 300+ reports are scheduled overnight (at a time and not via triggers/events) ready for the users the following morning.
If the APS were to fail (which it does occasionally), the backlog of reports is such that there are some that need to be run first over others, which are a lower priority.

At the moment I have to trawl through the lesser reports and put the backlogged recurring instances on hold - which takes a long time to do!

I just want to get round this problem when we migrate.

Cheers

Steve - Network Coordinating in the UK

 

[bdreed35]

There are 2 options that I can think of.

One is to offset the times that the reports are scheduled to run. If you schedule the higher priority reports to run first, they will run first.

The second is to create server groups. This would require a second job server and possiby a cache server and assign them to one server group, and then assign the original job and cache server to another server group. For the high priority reports, you can assign them to give preference to one of the server groups under the process tab of the report object. I would then assign the other reports to the other server group. This would give the high priority reports there own servers to run on giving them some priority over the others.

~Brian

 

[martinjbailey]

APOS have a wide assortment of utilities for the Enterprise environment ... might be worth a look.

One 'event' to mull over is the Success/Failure event trigger, though with 300 reports this could take a while to organise ;-)

Martin

 

[OldSkoolSkater]

bdreed35

Like the 2nd option that you specced. The high priority reports getting their own jobserver - I well may go that way.
It's a shame that Enterprise doesn't support prioritising as standard though...

Cheers

Steve - Network Coordinating in the UK

 

[KingfisherINC]

Take a look at Object Packages too. This allows you to logically group reports and manage their schedule / event properties.

Kingfisher [CECP]