Does anyone know how to prioritise reports?
I tried scheduling 50 reports to kick off at the same time, 10 going to Job Server 1 which has a 10 job capacity, 12 going to Job Server 2 which has a 12 job capacity, and the rest going to Job Server 3 which has an 18 job capacity. However I don’t want to restrict Jobs to only run on a designated server because I don’t want spare capacity going to waste. I hoped that all thre Job 1’s and 2’s would run straightaway but some got delayed behind Job 3’s running on Job Servers 1 & 2.
My question is how do I effectively prioritise reports? Do I just need to schedule the priority 1 reports 1 minute earlier? Or do I have to give priority reports their own exclusive job server?
AND how do people get round the fact that reports need to be scheduled BEFORE an event?
My issue is that the event could happen anytime in the morning, is the only way to ensure that the reports run to schedule them for 0100 or something like that?
Many many thanks!
perrin (BOB member since 2006-07-24)
You could use Server Groups to get you close to where you want to be. When you schedule a report you can use any server group, give preference to a group, or restrict to a group. In your case you could to create a couple groups from your three servers to approximate the priorities you want.
Maybe put the 12 and 10 capacity Servers (1 and 2) as a High group, put big Server 3 as a Low group and then possibly put Servers 1 and 3 as Medium. (Servers can be in more than one group, so you could use one server in both groups to create some flexibility.) Restrict the second set of reports to lesser priority groups and give priority to the High group for higher importance reports so that Lows don’t ever displace Highs and yet if the Low server is free you can use it for important stuff. Or do something completely different - you can make this as complex as you want to. I think I’d just split 1&3 and 1&2 and strat them at different times.
But yes, before you get into all the rest of this you want to schedule the important ones a minute or two ahead of the hoi polloi. That’ll probably fix most of the problems.
Cris E 
(BOB member since 2005-03-18)
Cheers, am going to experiment to see what results I get but this is good advice (didn’t realise servers could be in more than one group!).
Have you any thoughts on when to schedule reports which rely on a trigger that varies in time? I guess if the trigger normally happens between 0500 and 0800 I should just schedule for 0400 or even 0300?
perrin (BOB member since 2006-07-24)
Have you made any progress on this? I would like to see your input and thoughts on this one?
vijaykollu (BOB member since 2003-05-08)