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 |
|