User Guide
Introduction
Setup
Dependency Agent
Projects
Steps
Triggers
Reporting
Services
Settings
Logs
Licensing
Schedule

SQL Trigger

The SQL Trigger runs a SQL Query and uses the result to fire the trigger.

SQL Trigger

Parameter Value
Connection Library Please ignore, not applicable for most cases.
Connection Provider Type of Connection String (Optional: provided by Connection Library).
Connection String Database Connection String (Optional: provided by Connection Library).
CommandTimeout The maximum time the SQL command can run before returning an error.
Command The SQL Query to run the query must return a single result. Example Query that returns the maximum value of the Modified Column in the Table MyTable: SELECT MAX([Modified]) FROM [MyTable].