SQL Task Properties

autoCleanup

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

columnName

Column Name

If resultProcessing is Success Result Set Contains (4) or Failure Result Set Contains (5); Name of a database column that is being checked for a specific value.

Y

columnOp

Operator

If resultProcessing is Success Result Set Contains (4) or Failure Result Set Contains (5); Operator being used for the comparison.

Valid Values:

• As String = =, As Value = 1
• As String = !=, As Value = 2
• As String = >, As Value = 3
• As String = >=, As Value = 4
• As String = <, As Value = 5
• As String = <=, As Value = 6
• As String = regex, As Value = 7

Default is = (1).

N

columnValue

Value

If resultProcessing is Success Result Set Contains (4) or Failure Result Set Contains (5); Value being compared, using the specified columnOp.

N

connection

Database Connection

Name of the Universal Controller Database Connection that defines the database.

Y
(unless connectionVar
is specified)

connectionVar

connectionVar

Database Connection Variable

Name of a variable that will be resolved at run time to the name of the Database Connection to use.

Y
(unless connection
is specified)

connection

exitCodes

Exit Codes

If resultProcessing equals Success Exitcode Range (2) or Failure Exitcode Range (3); Range of exit codes.

Format: Numeric. Use commas to list a series of exit codes; use hyphens to specify a range. Example: 1,5, 22-30.

N

maxRows

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

resultProcessing

Result Processing

Specification for how the Controller should determine whether the SQL command failed or completed successfully.

Valid Values:

• As String = Skip Result Processing, As Value = 1
• As String = Success Exitcode Range, As Value = 2
• As String = Failure Exitcode Range, As Value = 3
• As String = Success Result Set Contains, As Value = 4
• As String = Failure Result Set Contains, As Value = 5

Default is Skip Result Processing (1).

N

retryIndefinitely

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

N

retryInterval

Retry Interval

Number of seconds between each retry.

Integer; Default is 60.

N

retryMaximum

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

retrySuppressFailure

Suppress Intermediate Failures

Specification for whether or not the following will be suppressed until all scheduled retry attempts have been made:

• All Actions (Abort, Email Notification, Set Variable, SNMP Notification, and System Operation) to be made against the task instance.
• Workflow conditional path processing; any Successors waiting on a failure path will not be released.
• Task Monitors will not be notified of the Failed status. Also, any Task Monitor task that has a Time Scope in the past will disqualify any matching task instance in the past with a Failed status if the task instance is scheduled for automatic retry and for which Suppress Intermediate Failures has been enabled.
• Any Workflow containing the Failed task instance will not transition to the Running/Problems status.

Boolean; Valid values: true/false. Default is false.

N

sqlCommand

SQL Command

SQL command being executed against the database.

Variables are supported.

Y