COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Event Studio => Topic started by: damienm on 21 Feb 2008 09:05:17 PM

Title: General Trigger Question
Post by: damienm on 21 Feb 2008 09:05:17 PM
I am new to Cognos and was just wondering how people in general trigger their reports to run and email. Basically I work in a AS400/JDE environment which Cognos hangs off, the problem we have with scheduling is that a number of our reports cannot run unable a exact/table in JDE has been updated, the timing of the update depends on the user and will occur at all different times, ideally I am thinking of setting up a table with a Y flag to indicate table updated so run the report, however it then needs to be changed once cognos report runs, does anyone use the same approach or have something better?

Title: Re: General Trigger Question
Post by: Rocks on 30 Sep 2008 03:52:23 PM
you could use the trigger functionality, and submit a batch file call at the end of your table builds. 

we do this today , once our ETLs are completed, we send a command through SSH to a wintel box, that executes a batch file with the cognos trigger.bat fuctionality.