Focal Point
[CLOSED] How-to queue ad-hoc report runs

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7177093306

May 06, 2011, 05:19 PM
dballest
[CLOSED] How-to queue ad-hoc report runs
Hi All,

Is there a way to queue an ad-hoc report request? We have a large data source and would prefer that users hit that source 1 at a time. Is this possible?

Thanks,
Dan

This message has been edited. Last edited by: Kerry,


Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE
May 06, 2011, 08:49 PM
Waz
I would suggest running the job deferred, and setting the/a WebFOCUS server up to have only one agent running at a time, and also turn on queuing.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

May 12, 2011, 04:48 PM
dballest
Waz,

How do you set the ad-hoc report as deferred? I think setting the agent to 1 would affect other reports. May I know what you mean by "turn on queuing"?

Thanks


Dev: WebFOCUS 7.6.10, Data Migrator 7.6.10
QA: WebFOCUS 7.6.10, Data Migrator 7.6.10
Prod: WebFOCUS 7.6.2, Data Migrator 7.6.8
Windows 2K3, Tomcat 5.5.17, IIS 6
Usage: HTML, PDF, Excel, Self-serve, BID and MRE
May 12, 2011, 06:19 PM
Waz
Where are the reports being run from ?

Queueing is set up in the WebFOCUS server, under Configuration/Data services, open the properties of one of the services.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!