Avoid sending email if report is blank

Question

Summary

Content

Hi all,

I have a report and scheduling to send to the recipients. If report does not have data, then i have to avoid sending email. How to do this?

Regards,

CK

Vimalbr · Answer

Use the select query with the report query and check the count before sent the email

YGUTTIKONDA · Answer

CK,

Use Triggers with your Scheduled JObs, this was you can skip the schedule if your condition is not met.

https://docs.oracle.com/cd/E28280_01/bi.1111/e22258/add_event_trig.htm#BIPDM389

Hope this helps ..

YG