Adf Sql Server Stored Procedure Activity Element
X-Ref:
- Ast Adf Sql Server Stored Procedure Activity Node
- Ast Adf Execution Activity Base Node
- Ast Adf Activity Base Node
- Ast Scope Boundary Node
Attributes
| Attribute | API Type | Default | Description |
|---|---|---|---|
| LinkedServiceName | AstAdfSqlServerLinkedServiceBaseNode | Specifies a reference to the linked service for the Azure SQL Database, Azure SQL Data Warehouse, or SQL Server that will be used for this activity. This is a required reference to an existing definiton. | |
| Name | String | Specifies the name of the object. This name can be used to reference this object from anywhere else in the program. This is a required property | |
| StoredProcedure | String | Specifies the name of the stored procedure that will be executed. This is a required property | |
| Retry | Int32 | -1 | Number of retry attempts. |
| RetryInterval | Int32 | 30 | Specifies the time in seconds between retry attempts. Range between 30 and 86400 with 30 being the default. |
| SecureInput | Boolean | False | Specify whether the input from the activity is sensitive and should not be logged to monitoring. |
| SecureOutput | Boolean | False | Specify whether the input from the activity is sensitive and should not be logged to monitoring |
| Timeout | String | "7" | Timeout for the activity to run. Defaults to 7 days. |
Singleton Children
| Child | API Type | Description |
|---|---|---|
| <Description /> | String | String is the .NET Framework String class. More information can be found at http://msdn.microsoft.com/en-us/library/system.string.aspx. |
| <Scheduler /> | AstAdfActivityScheduleNode | AstAdfActivityScheduleNode objects correspond directly to scheduler specifications for activities in Azure Data Factory. |
Collection Children
| Child | API Type | Description |
|---|---|---|
| <Annotations> <Annotation /> </Annotations> | AstAnnotationNode | This is a collection of annotation items that can be used to specify documentation, tags, or other information. Annotations are particularly useful for storing information about nodes that can be used by BimlScript code. |
| <Dependencies> <Dependency /> </Dependencies> | AstAdfActivityDependencyNode | This is the collection of activity dependencies that will control the execution of this Azure Data Factory activity. |
| <PipelineParameters> <Parameter /> </PipelineParameters> | AstAdfPipelineParameterNode | This is the collection of parameters that will be available to expressions in this Azure Data Factory activity. These parameters will be promoted automatically to the parent pipeline. |
| <StoredProcedureParameters> <Parameter /> </StoredProcedureParameters> | AstAdfStoredProcedureParameterNode | This collection contains the parameters that will be passed to the stored produre for execution. |
| <UserProperties> <UserProperty /> </UserProperties> | AstAdfActivityUserPropertyNode | This is the collection of user properties that the user can monitor in the Adf monitor window. |