Agents

Question

Hello Experts,

I have a question here. Am trying to schedule a report which has 100 rows on it and i did that it is working fine. From past 2 weeks we are having DB issues. Now the user is asking us to get the error message when report fails to his/her email ? Can we do this in OBIEE 11G or 12c ?

Please help me out here.

Regards,

Ahmed.

Sagar Tippe · Answer

In addition to what Martin said, you can configure a TRIGGER at database level which will send an email whenever there is an entry to the above mentioned tables.!!

Hope this helps..

Sagar Tippe

Martin van Donselaar · Answer

Sure, you can get the error message from S_NQ_ERR_MSG. You can see which jobs have failed in S_NQ_JOB. Both table are in the RCU schema.

You will have to create another agent that will check for errors regularly. I don't think you can have obiee send a message (out of the box) as soon as the agent fails.