I have an issue I'd like to share with you, in SP2010.
Here is the situation: There are a big number of sites, let's say 500, within one or different site collections. In each site, there's a similar list (let's say a task list) with several task elements.
Every 5 minute, a timer job is supposed to run so as to check if a task is due or late and if so, trigger an alert by email to the user whose task is assigned.
Which best practise should we implement so as to be sure that ALL the sites will be "scanned" by the timer job within the time it has before the next run ?
Thank you by advance for your ideas, warnings or other replies to this topic !