Cognos 8 - Trigger Based Scheduling

[cognos8.2]

Hi All,

Has anyone tried trigger based scheduling ? I have a requirement where in I need to schedule a report based on a trigger and email the report as an attachment to the users.

Any idea in this regard would be of great help!


Thanks in advance
Best Regards

[cognos8.2]

I guess there are two options, one with SDK & other without SDK. Let me know both the options.

Thanks!

[Rocks]

We have started to use triggers based on completion of ETL Data Warehouse and Mart completions.  Bascially we have added a call at the end of selected ETL jobs that SSH over to our transformer box (we put all of our triggers here because we are also calling cube build scripts through a similar process), and call tiggers that fire off groups of reports.

You could take this same functionality and add it to a windows scheduler, where at X time, Y trigger batch file gets kicked off.  You place the name of the trigger in the batch file, and then use that same name on the scheduler-->trigger tab within cognos connection.

All of this is done without the use of SDK.  If you want to get even more creative than this, then you will probably need to start investigating SDK solutions....

Hope this helps...:D

[cognos8.2]

Thanks Rocks.

In cognos 8 environment, there is a utility trigger.sh which needs to be invoked from the unix platform. any idea on how to process this to fire a cognos 8 trigger, and execute a group of reports.

Pls help..

[Rocks]

I dont know how to do it from Unix, however here is one of our triggers on the Windows platform.  I have also incorporated a little bit of logging into this trigger. 

ECHO %DATE% %TIME% >>D:\Programs\c8mr2\webapps\utilities\trigger\Triggerlog.txt
trigger.bat http://**IP address of dispatcher**/p2pd/servlet/dispatch **userid * *Password** ADS Cement_Daily_Shipping_Trigger >>D:\Programs\c8mr2\webapps\utilities\trigger\Triggerlog.txt

Broken down....

**This puts the date and time into a file called "Triggerlog.txt" in the same location as the triggers. (note, that you HAVE to run your triggers from this directory)
ECHO %DATE% %TIME% >>D:\Programs\c8mr2\webapps\utilities\trigger\Triggerlog.txt

**Standard call of the trigger.bat file.  This batch file is never changed...rather you are creating a new batch file to call this batch file.
trigger.bat

**Your dispatcher address.  If you dont know this, you can get it from Cognos Configuration under "Dispatcher URI for external applications.  One note here....I found that you have to use an IP address in lieu of a mapped URL...i.e. HTTP:\\bi.na.company....
http://**IP address of dispatcher**/p2pd/servlet/dispatch

**Login and password to run the triggers.  Usually a sys admin or super user. 
**userid * **Password**

**Namespace.  We map to AD.
ADS

**The name of your trigger as it appears when you schedule it on the Trigger tab
Cement_Daily_Shipping_Trigger

**Another call to the log file to write out the result of the trigger call.
>>D:\Programs\c8mr2\webapps\utilities\trigger\Triggerlog.txt


I hope this works for you.  If you need more details on the syntax for a Unix call, you should be able to find it either in the Admin and Security guide, or on the KB.

[cognos8.2]

Thanks once again,  Rocks.

This was a great help!

[JeffR]

For those checking this thread who are interested in firing a report from a UNIX system that is not running Cognos, take a look at the following IBM article:

http://www-01.ibm.com/support/docview.wss?rs=0&q1=1030046&uid=swg21341613&loc=en_US&cs=utf-8&cc=us&lang=en

[mvjcognos]

try this

1) Click on Schedule button u will find by day,by week,by month,by year and trigger.
2) Click on trigger then u will find in the right side of the page trigger name
there give ur trigger name for ex: FTTPZ20
3) Down to that ename option will be there click on that select the email add.
4) Finish...................

When ever the trigger runs that time report will run. Ur administrator will give particular time and date to the trigger that time it will run automatically...........

[Malosa]

Hello
We have a similar requirement here and I was wondering if someone can provide me details of how to schedule the jobs using the BY trigger option.
Do we need to create a trigger file ? I guess I am not clear on how to do this process -Rock - perhaps can you help me better understand what you suggested ?

Thank you very much for your help

Best regards
Mala

[Malosa]

Also, I forgot to mention - we want to do it without the SDK route
Thanks again
Mala

[mahgar]

What should I put here,

if [ "$CRN_HOME" = "" ]; then
   CRN_HOME="../../../"
fi

if [ "$JAVA_HOME" = "" ]; then
   JAVA_HOME="../../../bin/jre/6.0/"
fi

JAR_HOME="${CRN_HOME}/webapps/p2pd/WEB-INF/lib/"


CLASSPATH=".:${JAR_HOME}/tools.jar"
for jar in activation axis axisCrnpClient commons-discovery-0.2 commons-logging-1.1 commons-logging-adapters-1.1 \
        commons-logging-api-1.1 jaxrpc mail resolver saaj serializer xercesImpl xml-apis wsdl4j-1.5.1 ; do
  CLASSPATH="${CLASSPATH}:${CRN_HOME}/webapps/p2pd/WEB-INF/lib/${jar}.jar"
done

${JAVA_HOME}/bin/java -classpath ${CLASSPATH} Trigger ${1} ${2} ${3} ${4} ${5}