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

Author Topic: Reloading Data Sets based on Triggers  (Read 1511 times)

Offline adam_mc

  • Statesman
  • ******
  • Join Date: Mar 2012
  • Posts: 314
  • Forum Citizenship: +15/-0
Reloading Data Sets based on Triggers
« on: 06 Oct 2020 08:35:47 am »
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,

Offline DaHammer

  • Full Member
  • ***
  • Join Date: Jun 2016
  • Posts: 19
  • Forum Citizenship: +0/-0
Re: Reloading Data Sets based on Triggers
« Reply #1 on: 08 Oct 2020 06:25:55 pm »
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.