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:

  • Equal to

  • Different from

  • Smaller than

  • Smaller or equal to

  • Greater than (default)

  • Greater or equal to

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 Custom SQL option is enabled.