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

Schedule based on Trigger

Started by jsjones, 27 Apr 2015 09:54:23 AM

Previous topic - Next topic

jsjones

We have just upgraded to Cognos 10.2.2.  Overall, everything has transferred over without too many issues.  However, I have a scheduled report that is based upon a trigger.  I have looked for events that may act as the trigger, but to no avail.  If this is a trigger in the database, how would I go about locating said trigger?  Is there anything I need to install in Cognos 10.2.2 in order to use database procedures as triggers?  Just need to figure out this one trigger............

cognos810

Hello jsjones,
Although very new to Cognos 10.2.2 and not sure if trigger based scheduling in 10.2.2 has changed in anyway or not, trigger based report scheduling(not to be confused with the concept of DB triggers) is basically a batch file that you create and pass on to the ETL/DB guys who then incorporate into one of their ETL jobs as a step. Example, run a report after the refresh of a specific table.
Generally the content of the trigger.bat file is as such...
trigger.bat http://CognosGatewayServerName/cognosSiteAlias/cgi-bin/cognos.cgi adminUserid adminPassword NamespaceID trigger1
Then your use the name trigger1 to schedule your report.
Your older Cognos X version implementation where you upgraded from should have this .bat file. All you need to do really is locate this file and change the cognos server URI to point to your new URI. If you migrated over from the older cognos environment with the scheduling information, the report would still have the scheduling set with this trigger name.

Depending on where you initiate this trigger.bat file you may need some more changes. The below link should assist you with the same.
https://www-304.ibm.com/support/docview.wss?uid=swg21370591

-Cognos810