Trigger Condition and email notifications

What are query emails used for?

E-mails are used as notifications to interested parties every time the trigger condition in a query is met.

When Trigger Condition is set to:

  • If query returns rows and query returns rows, we get an email with the resulting rows.
    • E.g. if the query tests if there are customers in the system without an address, we would get an email with the query results.
  • If query returns no rows and query returns no rows, we get an email with selected table columns but no rows below.
    • E.g. when a data warehouse table is empty, we would get an email with column names but no rows.

image

 

 

 

 

There are two types of email notifications

  1. Email Task (Tasks tab) can be turned on manually and a user can add as many email tasks as wanted.
    • Email tasks contain all the resulting rows in a query in every single email.
  2. Exception Manager can be enabled and email deliveries after that.
    • Emails are automatically delivered to the Query Owner.
    • A user can choose between getting only new exceptions (since the query was last run) and getting all open exceptions.

 

For further details, see Configuring email notifications.

exMon Contact Us