Row count triggers simply trigger if the number of rows returned from the query are greater than or less than the specified row count.  These are by far the simplest triggers and make it very easy to look for conditions that exist in the database.  Write a SQL statement that looks for a condition within the database, if this is found the monitor will trigger.


For example, if we never expected the price of a book to exceed $500.00 the following query would look for that condition and the monitor would only trigger if that condition existed.  Additionally, any rows returned from this query would be included in the email notification and highlighted on the monitor view page.


SELECT * FROM examples.Books WHERE Price > 500



Options:

  • Min Row Differences
    • Minimum number of rows allowed to return from the query
  • Max Row Differences
    • Maximum number of rows allowed to return from the query
  • Send Notification Once
    • Monitor will only trigger and send a notification one time.  It will send a notification again unless it returns to a passing state and then triggers again.  This reduces the number of notifications that are sent by QuickReportz if for example a monitor is scheduled to run frequently and notifications are not wanted to be sent on every failure.