If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

scheduling batch jobs for a large number of reports

Started by LemonHead, 18 Nov 2011 10:48:05 AM

Previous topic - Next topic

LemonHead

Hello group,

I would like to automatically send a report to all of my customers at the end of every month. My customers are stored in an Oracle database table. My concern is that I have several million customers, but the reports must all be delivered in a timely fashion. I do have the capability to balance the load over several processors; however, I'm not sure about the best way to implement the division of labor (i.e., processing the reports in "chunks"). Does Cognos have a facility that would help with this, or will I need to roll my own?

Thank you.

sir_jeroen

Don't forget your mail server.. Is it capable of sending such a great amount of mails in a timely fashion?
And furthermore... Does your license cover this because if i'm correct all the clients that get this mail are considered to be recipients... (correct me if i'm wrong)

And the greatest load will be made on your contentstore because that's the one part which isn't load balanced (in a multi server environment there can only be 1 active content manager!) So the most stress will be on your content manager i think...

And I would also recommend you to use bursting, because then the chunking is handled by Cognos and the report will be executed only once and the results will be chunked into smaller outputs by Cognos instead of running the report numerous times... You could also consider bursting the output to disk and then use a mass mailer to send the output....