BIP update database once report published

Question

Summary

Content

Is there anyway to update the oracle database once an event like BIP sends an email for a specific client report occurs, we update dB so if we run the job again this client is not emailed again.

Venkat Thota - BIP · Answer

I think the failure jobs are storing in  XMLP_SCHED_JOB(status column) , you can create simple query on top this tables to retrieve failed jobs for a time and you can re-run  again ,

OR

You can setup notifications for each report that will send notification to your email (success , warning or failure),

Setting Up Delivery Destinations

YGUTTIKONDA · Answer

Did you try using Event Triggers ? Check the XDO user guide for more info