Categories
- All Categories
- 101 Oracle Analytics News
- 9 Oracle Analytics Videos
- 14.3K Oracle Analytics Forums
- 5.3K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 56 Oracle Analytics Trainings
- 60 Oracle Analytics Data Visualizations Gallery
- 4 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 4 Oracle Analytics Industry
- 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