Set up a task trigger that fires if data in a database changes

As an example we'll set up a trigger that goes off whenever data for the latest day arrives.

1. In the new task window under the 'Triggers' tab click the '+' button:
2. From the top dropdown select the 'ODBC SQL / sproc returns records' trigger:
3. Select the database connection and then enter the SQL.

If the query returns any records then the trigger will fire once. It will reset whenever the query doesn't return data again.
4. The trigger will now show up in the task window:

And that's it!

For more advanced tasks please see other sections of the how-to guide.

Download for free