Hello Everyone,
This is a same question ,I had asked earlier.Please help me on the same.
Does cognos have the option of alerting the users by email when a scheduled report fails.Just sending whatever error or any message when the report fails and send the error or message by email
Please help me on the same.
Thanks
Vinod
I dont recall such functionality exist in Cognos.
The only way to do it is to create your own script + use SDK.
Quote from: vincognos on 26 Aug 2008 10:33:23 AM
Hello Everyone,
This is a same question ,I had asked earlier.Please help me on the same.
Does cognos have the option of alerting the users by email when a scheduled report fails.Just sending whatever error or any message when the report fails and send the error or message by email
Please help me on the same.
Thanks
Vinod
Yes it possible, you need to enable audit logging to a database and
use event studio to query the audit table for errors.
User BI007 is correct:
I have done this in the past (only I sent e-mail to self - upon report failure):
First you would have to setup Auditing and an Audit database (if you haven't done so already). I believe instructions exist on this process in the Cognos Administration & Security Guide.
Then, a table will exist in your audit database, that will contain this information (report failure data):
Run Reports or View Reports table: a Status exists in these two tables.
In Event Studio, you can then setup an expression [Status]='FAILURE'
If a report fails during execution - send e-mail to user x, etc.
Hope this helps.
Once you have setup the audit database go to
In my PC
C:\Program Files\cognos\c83\FM\Dev\webcontent\samples\content
look for Cognos_Audit.zip a framework manager package exists. open this package
you can query the [COGIPF_ACTION].[ERROR DETAILS] table.
More details can be found here.
http://support.cognos.com/supported/tti/public/docs/cognos_pp_reporting_monitoring_the_audit_database_using_event_studio.pdf?lid=cognos_pp_reporting_monitoring_the_audit_database_using_event_studio
Hope this helps