COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Cognos Connection, Viewer, Scheduler => Topic started by: Graigor on 21 Mar 2017 07:51:49 AM

Title: Is there a maximum background activities limit?
Post by: Graigor on 21 Mar 2017 07:51:49 AM
Hi,

We are planning on starting many trigger at the same time for month end.  Before they were started "by hand" by somebody one after the other.

We want to automate the process and would like to fire them all at the same time.   14 triggers would start around 500 event studio jobs at the same time.

Do you think it would work?  Is there a limit to the amount of jobs that can be pooled?

thanks
Title: Re: Is there a maximum background activities limit?
Post by: MFGF on 22 Mar 2017 05:29:43 PM
Quote from: Graigor on 21 Mar 2017 07:51:49 AM
Hi,

We are planning on starting many trigger at the same time for month end.  Before they were started "by hand" by somebody one after the other.

We want to automate the process and would like to fire them all at the same time.   14 triggers would start around 500 event studio jobs at the same time.

Do you think it would work?  Is there a limit to the amount of jobs that can be pooled?

thanks

When you fire off reports in the background, they are processed using the batch report service. Your Cognos instance has a defined number of batch report services, and a defined number of connections for each service (set by your Cognos administrator). If you have (eg) 4 services and each has 4 connections, this means the server can process 16 reports concurrently in the background. Any further background requests will be queued, and wait for the next available connection to become free. Also there is a default queue time limit expiry setting defined by your administrator, and any reports in the queue for longer than this limit get bounced and do not run.

In summary, it all depends on the processing capacity of your Cognos server(s), and the settings configured by your administrator.

Cheers!

MF.