...
Step 1 | From the Automation Center navigation pane, select Tasks > Stored Procedure Tasks. The Stored Procedure Tasks list displays a list of all currently defined Stored Procedure tasks. |
---|---|
Step 2 | Enter/select Details for a new Stored Procedure task, using the field descriptions below as a guide.
To display more of the Details fields on the screen, you can either:
|
Step 3 | Click a button. The task is added to the database, and all buttons and tabs in the Task Details are enabled. |
...
Depending on the values that you enter / select for these fields, and whether or not the Stored Procedure task has ever been launched, more (or less) fields may display. See the field descriptions, below, for a description of all fields that may display in the Stored Procedure Task Details.
Anchor | ||||
---|---|---|---|---|
|
...
The following Stored Procedure Task Instance Details contains information on the execution of the task shown in the Stored Procedure Task Details.
Anchor | ||||
---|---|---|---|---|
|
...
Field Name | Description | ||||||
---|---|---|---|---|---|---|---|
Parameter Position | Position of this parameter within a list of parameters. | ||||||
| Mode of this parameter.
| ||||||
Parameter Type | Type of parameter.
| ||||||
Value is Null | If Parameter Mode = Input or Input/Output; Value for the parameter is a database NULL value; applies to the input part of a stored procedure parameter. That is, if a value in a database is undefined, it is NULL, which means it has no set value. An input value can be NULL and is represented by selecting Value is Null. | ||||||
Input Value | If Parameter Mode = Input or Input/Output; Input value of the parameter (up to a maximum of 4000 characters), if any. | ||||||
Description | Description of this parameter. | ||||||
Variable Scope | If Parameter Mode = Output or Input/Output; applies to parameters associated with a task in a workflow. Scope of the variable to assign the Output value.
| ||||||
Variable Name | If Parameter Mode = Output or Input/Output; name of variable to assign the Output value. |
...