Wait for SQL
Description
The Wait for SQL action scans a database and checks if the database meets user-defined conditions.
Options
| Option | Description |
|---|---|
Action name | The name of the workflow action. |
Connection | Identifies the database connection to use. |
Target schema | Name of the table schema to evaluate. |
Target table name | Name of the table to evaluate. |
Success condition | |
Success when rows count | Defines the evaluation method used to compare the number of rows with the given value. The options are:
|
Row count value | Defines the row count value used for the evaluation |
Maximum timeout | After this timeout period, the workflow action continues with a fail, by default, or success, if the Success on timeout option is checked. Expressed in seconds, 0 is infinite. |
Check cycle time | Sets the amount of time between evaluations, expressed in seconds. |
Success on timeout | Defines workflow action success behavior when timeout is reached---when checked, reaching the maximum timeout limit causes the workflow action to succeed. When left unchecked, reaching the maximum timeout limit causes the workflow action to fail. |
Custom SQL | |
Custom SQL | Enables the use of custom SQL queries. |
Use variable substitution | Replaces environment variables in the SQL script with their actual value. |
Clear list of result rows before execution | Clears the list of result rows before running this workflow action. |
Add rows to result | Includes returned rows to the result set. |
SQL Script | The custom SQL script to use when the |