Property | UI Field Name | Description | Specifications | Required | Mutually Exclusive With |
|---|
| Anchor |
|---|
| autoCleanup- SP |
|---|
| autoCleanup- SP |
|---|
|
autoCleanup | Auto Cleanup | Specification for whether or not data retrieved as the result of a SQL task and then 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 | |
|
| Anchor |
|---|
| columnName - SP |
|---|
| columnName - SP |
|---|
|
columnName | Column Name | If resultProcessing is Success Result Set Contains or Failure Result Set Contains; Name of a database column that is being checked for a specific value. |
| N | |
|
| Anchor |
|---|
| connection - SP |
|---|
| connection - SP |
|---|
|
connection | Database Connection | Universal Controller Database Connection that defines the database. |
| Y
(unless connectionVar
is specified) | connectionVar
|
| Anchor |
|---|
| connectionVar - SP |
|---|
| connectionVar - SP |
|---|
|
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
|
| Anchor |
|---|
| exitCodes - SP |
|---|
| exitCodes - SP |
|---|
|
exitCodes | Exit Codes | If resultProcessing is Success Exitcode Range or Failure Exitcode Range; 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. This value overrides any value specified in the selected Database Connection. | Integer. | N |
|
| Anchor |
|---|
| parameterPosition - SP |
|---|
| parameterPosition - SP |
|---|
|
parameterPosition | Parameter Position | If resultProcessing is Success Output Parameter or Failure Output Parameter; Position of this parameter within a list of parameters. | Integer. | N |
|
| Anchor |
|---|
| resultOp - SP |
|---|
| resultOp - SP |
|---|
|
resultOp | Operator | If resultProcessing is Success Result Set Contains, Failure Result Set Contains, Success Output Parameter, or Failure Output Parameter; Operator being used for the comparison. | Valid values:| Html bobswift |
|---|
<ul>
<li>As String =
<li>As
<li>As
<li>As
<li>As
<li>As
<li>As
</ul>Default is = (1). | N | |
|
| Anchor |
|---|
| resultProcessing - SP |
|---|
| resultProcessing - SP |
|---|
|
resultProcessing | Result Processing | Specification for how the Controller should determine whether the Stored Procedure failed or completed successfully. | Valid values:| Html bobswift |
|---|
<ul>
<li>As String = Skip Result Processing, As Value = 1
<li>As String = Success Exitcode Range, As Value = 2
<li>As String = Failure Exitcode Range, As Value = 3
<li>As String = Success Result Set Contains, As Value = 4
<li>As String = Failure Result Set Contains, As Value = 5
<li>As String = Success Output Parameter, As Value = 6
<li>As String = Failure Output Parameter, As Value = 7
</ul> - 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
- As String = Success Output Parameter, As Value = 6
- As String = Failure Output Parameter, As Value = 7
Default is Skip Result Processing (1). | N |
|
| Anchor |
|---|
| resultValue - SP |
|---|
| resultValue - SP |
|---|
|
resultValue | Value | If resultProcessing is Success Result Set Contains Range, Failure Result Set Contains, Success Output Parameter or Failure Output Parameter; Value being compared, using the operator specified in resultOp. | |
| N | |
|
| Anchor |
|---|
| retryIndefinitely - SP |
|---|
| retryIndefinitely - SP |
|---|
|
retryIndefinitely | Retry Indefinitely | Specification for whether or not the Controller should continue trying indefinitely to run this task. This value overrides any value in retryMaximum. | Boolean; Valid values: true/false. Default is false. | N |
|
| Anchor |
|---|
| retryInterval - SP |
|---|
| retryInterval - SP |
|---|
|
retryInterval | Retry Interval (Seconds) | Number of seconds between each retry. | Integer; Default is 60. | N | |
|
| Anchor |
|---|
| retryMaximum - SP |
|---|
| retryMaximum - SP |
|---|
|
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 | |
|
| Anchor |
|---|
| retrySuppressFailure - SP |
|---|
| retrySuppressFailure - SP |
|---|
|
retrySuppressFailure | Suppress Intermediate Failures | If the task instance is in the Failed status; Specification for whether or not the following will be suppressed until all scheduled retry attempts (a retryMaximum value has been specified or retryIndefinitely is true): - 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 | |
|
| Anchor |
|---|
| storedProcName - SP |
|---|
| storedProcName - SP |
|---|
|
storedProcName | Stored Procedure Name | Name of the file containing the stored procedure being executed against the database. Variables are supported. |
| Y |
|
