mail notification to recipient based on run history using cognos event studio

[laxmanrao83]

Hi All,

Please help me resolve the below issue.

I have schedule the cognos report studio report ,if the report has failed in any cases i needs to send a mail to users  saying that report has got failed.

I heard like above requirement can be achieve the   using cognos event studio.
Could you please provide the procedure to achieve the above scenario in cognos event studio.

Thanks & Regard,
Laxman

[teresa.danna@gmail.com]

First you will need to determine how often the report will run. My example will use nightly.

1) Set up the event based on your timeline and if the report failed something like:
Current_date > _add_days(current_date,-1) and [Report] = 'ReportA' and [Status] = 'Fail'

2) Then insert a task to run an email

3) Within the body of the email insert a table and whatever verbiage you want. In the top row type out the header, whatever data you need to send to the user.
For example you could type, Report in the top left row and then put the [Report] object into the row below it.

4) Save the event

5) Find the event in cognos connection and schedule it to run based on the time filter you used in #1.

Good luck!

[ra]

Hi Teresa,

I'm also facing same problem, Could you send any link for this solution or share the related doc if you have.

Thanks,
Ram

[Raghuvir]

Hi All,

Does the information for event failure gets stored in any of the table in content store ?

Regards

[ra]

Hi Raghuvir,

All the failed reports get locked in audit able, you can check in audit table .


Thanks,
Ram

[ra]

Hi Teresa,

I implimented your logic in Event studio and scheduled the report and the report status is showing like success but not able to reveice any email from enivornment.
and getting the error like "CNC-ASV-0050 Event condition not met.".

Could you please help on  this issue.

Thanks,
Rams