Run a scheduled report only showing changes from last run report.
I am trying to figure out how I could run a scheduled report that will only show me the changes that have occurred from the last run report? I have a report that runs every hour from an SQL query. However what I would like is to only show the data that was not present in the previous report. I know I can have the SQL script run to limit the data from the previous hour, but what happens if this report fails to run for 2 consecutive runs?