• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 500
  • Last Modified:

How can I set up to email a report only if there is data using infoview

I created a report to run hourly & emailed to several people.
I only want the report to be emailed if there's data.
0
allemis
Asked:
allemis
1 Solution
 
LinInDenverCommented:
I have accomplished this with triggers (events) before in the CMC.

i.e.: query runs against database, and if it is true, it will place a file in a specific directory. if CMC sees the file exists, it will run as scheduled. You would need to create a File Event in the CMC, and then re-schedule your hourly report to be based on that Event in addition to the hourly schedule.

Research Events  a bit to see if you can make it work for you to.

0
 
mlmccCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now