My user wants to run the report when a new data is inserted in the database. i want to conform that can I use trigger schedule for this or any other way to run the report?
Quotei want to conform that can I use trigger schedule for this
---
YES
Hi there
Look for the following IBM Technotes
I've found if I enter a URL it kills the thread in cognoise so I'm now just entering the references so you'll have to google the information
keywords "IBM Cognos schedule trigger bat"
Technote
How to fire a trigger using the Trigger.bat utility - Reference #: 1340069
Online documentation
In the IBM Cognos online documentation search for "SetUpTriggerEventsonaServer"
IBM Proven practices guide
IBM Cognos Proven Practices: Automating Deployment of IBM Cognos 8 BI (page523)
Hope this helps
BTB: We use trg files from the database which are then picked up by an product called ActiveBatch as a schedule search which if the trg file exists, triggers a batch script to run the schedule in Cognos. Nice and clean
Cheers
Peter B