cancel
Showing results for 
Search instead for 
Did you mean: 

BI 4.2 - Notification for Failed Reports

Former Member
0 Kudos
332

Hi Experts,

I was wondering if in the new BO 4.2 version is possible to create a report or query from the Audit that spool everyday/hour the list of the reports that have failed.

I know there is a notification in the scheduling job but I would like something proactive without have to add a notification to all the scheduling jobs

Regards

Ercole

Accepted Solutions (1)

Accepted Solutions (1)

former_member205064
Active Contributor
0 Kudos

Hi Ercole,

check few sample audit reports are present here:-

if these report does not fulfill your requirement then you will have to manually create one.

Former Member
0 Kudos

Hi Raunak,

Thanks very much for this article. This is a good start. I'll download the universe and I'll load in our development deployment for testing

Regards

Ercole

former_member205064
Active Contributor
0 Kudos

I agree best way to start!

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Ercole,

I was using the below SQL on the audit database for other reasons related to scheduling.

Event Type ID=1011 (Run) captures all the scheduled events. You can filter the result further by Object Name, Object Type and Start Time of the event.

select * from ADS_EVENT where Event_Type_ID=1011 and Object_name='Webi Heart Beat v1.0'