Task Properties: Stored Procedure 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 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 |
|
|
Column Name |
If |
|
N |
|
|
Database Connection |
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. This value overrides any value specified in the selected Database Connection. |
Integer. |
N |
|
|
Parameter Position |
If |
Integer. |
N |
|
|
Operator |
If |
Valid values: Default is = (1). |
N |
|
|
Result Processing |
Specification for how the Controller should determine whether the Stored Procedure failed or completed successfully. |
Valid values: Default is Skip Result Processing (1). |
N |
|
|
Value |
If |
|
N |
|
|
Retry Indefinitely |
Specification for whether or not the Controller should continue trying indefinitely to run this task. This value overrides any value in |
Boolean; Valid values: true/false. Default is false. |
N |
|
|
Retry Interval (Seconds) |
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 |
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
|
Boolean; Valid values: true/false. Default is false. |
N |
|
|
Stored Procedure Name |
Name of the file containing the stored procedure being executed against the database. Variables are supported. |
|
Y |
|