SQL Task Properties
Task Properties: SQL Task
Property | UI Field Name | Description | Specifications | Required | Mutually Exclusive With |
---|---|---|---|---|---|
| Auto Cleanup | Specification for whether or not data retrieved as the result of a SQL task and written into a database table is discarded upon the successful completion of the task (or workflow if the task is contained within a workflow). | Boolean; Valid values: true or false. Default is false. | N | |
| Column Name | If | Y | ||
| Operator | If | Valid Values:
Default is = (1). | N | |
| Value | If | N | ||
| Database Connection | Name of the Universal Controller Database Connection that defines the database. | Y |
| |
| Database Connection Variable | Name of a variable that will be resolved at run time to the name of the Database Connection to use. | Y |
| |
| Exit Codes | If | Format: Numeric. Use commas to list a series of exit codes; use hyphens to specify a range. Example: 1,5, 22-30. | N | |
| Maximum Rows | Limit to the number of rows you want returned by the SQL statement. | Integer; this overrides any value specified in the selected Database Connection. | N | |
| Result Processing | Specification for how the Controller should determine whether the SQL command failed or completed successfully. | Valid Values:
Default is Skip Result Processing (1). | N | |
| Retry Indefinitely | Specification for whether or not the Controller should continue trying indefinitely to run this task. | Boolean; Valid values: true/false. Default is false. This value overrides any value specified in | N | |
| Retry Interval | Number of seconds between each retry. | Integer; Default is 60. | N | |
| Maximum Retries | Maximum number of times that the Controller should retry this task after it has started and gone to a failed state. | Integer; Default is 0. | N | |
| Suppress Intermediate Failures | Specification for whether or not the following will be suppressed until all scheduled retry attempts have been made:
| Boolean; Valid values: true/false. Default is false. | N | |
| SQL Command | SQL command being executed against the database. | Variables are supported. | Y |