Triggers
SQL Trigger
The SQL Trigger runs a SQL Query and uses the result to fire the trigger.
| Parameter | Value |
|---|---|
| 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]. |