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
. 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