Alerting groups or users when report fails

[vincognos]

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

[josepherwin]

I dont recall such functionality exist in Cognos.

The only way to do it is to create your own script + use SDK.

[praveennb]

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.

[CognosPolzovatel]

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.

[praveennb]

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