SqlServerStoredProcedureActivity interface

SQL stored procedure activity type.

Extends

Properties

storedProcedureName

Stored procedure name. Type: string (or Expression with resultType string).

storedProcedureParameters

Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

type

Polymorphic discriminator, which specifies the different types this object can be

Inherited Properties

dependsOn

Activity depends on condition.

description

Activity description.

linkedServiceName

Linked service reference.

name

Activity name.

onInactiveMarkAs

Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.

policy

Activity policy.

state

Activity state. This is an optional property and if not provided, the state will be Active by default.

userProperties

Activity user properties.

Property Details

storedProcedureName

Stored procedure name. Type: string (or Expression with resultType string).

storedProcedureName: any

Property Value

any

storedProcedureParameters

Value and type setting for stored procedure parameters. Example: "{Parameter1: {value: "1", type: "int"}}".

storedProcedureParameters?: any

Property Value

any

type

Polymorphic discriminator, which specifies the different types this object can be

type: "SqlServerStoredProcedure"

Property Value

"SqlServerStoredProcedure"

Inherited Property Details

dependsOn

Activity depends on condition.

dependsOn?: ActivityDependency[]

Property Value

Inherited From ExecutionActivity.dependsOn

description

Activity description.

description?: string

Property Value

string

Inherited From ExecutionActivity.description

linkedServiceName

Linked service reference.

linkedServiceName?: LinkedServiceReference

Property Value

Inherited From ExecutionActivity.linkedServiceName

name

Activity name.

name: string

Property Value

string

Inherited From ExecutionActivity.name

onInactiveMarkAs

Status result of the activity when the state is set to Inactive. This is an optional property and if not provided when the activity is inactive, the status will be Succeeded by default.

onInactiveMarkAs?: string

Property Value

string

Inherited From ExecutionActivity.onInactiveMarkAs

policy

Activity policy.

policy?: ActivityPolicy

Property Value

Inherited From ExecutionActivity.policy

state

Activity state. This is an optional property and if not provided, the state will be Active by default.

state?: string

Property Value

string

Inherited From ExecutionActivity.state

userProperties

Activity user properties.

userProperties?: UserProperty[]

Property Value

Inherited From ExecutionActivity.userProperties