How To
Summary
How to set up email notification of failed jobs in your Cognos environment without having to log in to the environment and constantly check the run history in Cognos Administration for failures.
Steps
1. Enable logging of audit data to a database (Please see the Installation and Configuration Guide and the Administration and Security Guide for information on audit logging: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ig_smples.doc/t_settingupauditreportlogging.html and https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cra.doc/t_setupauditreports.html).
2. Create an agent in Event Studio using the package for the audit data. Define the condition COGIPF_RUNJOB.COGIPF_STATUS=Failure OR COGIPF_RUNREPORT.COGIPF_STATUS=Failure.
The agent uses a query to retrieve the report name/path when the status of the report execution is an error state. This gives you a list of reports which have produced errors.
3. In the Event Studio agent, you would then create an email task, which will operate for new events only. The email can be sent to an administrator of the environment to follow up on why the report produced an error (See the Event Studio User Guide for information on creating an agent, setting up the condition, and defining an email task: https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_cr_es.doc/c_ug_cr_as_ovrvw_evnt.html#ug_cr_as_ovrvw_evnt.
Additional Information
Document Location
Worldwide
Was this topic helpful?
Document Information
Modified date:
09 January 2023
UID
ibm16379764