Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BIP update database once report published

Received Response
11
Views
2
Comments

Summary

BIP update database once report published

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.

Answers

  • YGUTTIKONDA
    YGUTTIKONDA Rank 6 - Analytics Lead

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

  • Venkat Thota - BIP
    Venkat Thota - BIP Rank 7 - Analytics Coach

    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