Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 190 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 65 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Avoid sending email if report is blank

User_JL3CW
Rank 6 - Analytics Lead
Summary
Avoid sending email if report is blank
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
1
Answers
-
Use the select query with the report query and check the count before sent the email
0 -
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
0