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



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

Main Menu

Reloading Data Sets based on Triggers

Started by adam_mc, 06 Oct 2020 08:35:47 AM

Previous topic - Next topic


CA 11.0.13

We have a corporate scheduler tool that we are going to utilize to kick-off Cognos Data Set refreshes by using the trigger.bat script and this is working as expected.
However, we want the scheduler script to not return until all triggered Cognos processes are complete (not just kicked off).

When needing this functionality with reports, I would put all reports in a Cognos job and trigger the job.
The last report in the job would create a finish.txt file which we could monitor for to give us a notification that all reports have completed normally.
However, there doesn't seem to be a way to add a Data Set reload to a job!

Does anyone know how this can be accomplished or know of an alternate way to give us similar functionality?

Thanks in advance,


You could use a small SDK app instead of the included trigger.bat utility. This way you can would first identify all jobs that are dependent on the trigger, and await for their completion before you return control to the external scheduler.