Home
  •  

MSSQL: 一般範本種子測試連線能力工作寫入動作

Microsoft.SQLServer.Core.Task.TemplateSeed.TestConnection.WA (WriteActionModuleType)

範本種子測試連線能力工作寫入動作

Element properties:

TypeWriteActionModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
InputTypeSystem.BaseData
OutputTypeSystem.PropertyBagData

Overrideable Parameters:

IDParameterTypeSelector
SqlExecTimeoutSecondsint$Config/SqlExecTimeoutSeconds$
SqlTimeoutSecondsint$Config/SqlTimeoutSeconds$資料庫連線的逾時 (秒)若工作流程無法在指定的期限之內存取資料庫，將會失敗並登錄一則事件。
TimeoutSecondsint$Config/TimeoutSeconds$逾時 (秒)指定工作流程失敗多少次後關閉並標示為失敗。
ConnectionStringstring$Config/ConnectionString$

Source Code:

<WriteActionModuleType ID="Microsoft.SQLServer.Core.Task.TemplateSeed.TestConnection.WA" Accessibility="Internal" Batching="false">

  <Configuration>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ConnectionString" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Login" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Password" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlExecTimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SqlTimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="TimeoutSeconds" type="xsd:integer"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Publisher" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="ManagementGroupName" type="xsd:string"/>

  </Configuration>

  <OverrideableParameters>

    <OverrideableParameter ID="SqlExecTimeoutSeconds" ParameterType="int" Selector="$Config/SqlExecTimeoutSeconds$"/>

    <OverrideableParameter ID="SqlTimeoutSeconds" ParameterType="int" Selector="$Config/SqlTimeoutSeconds$"/>

    <OverrideableParameter ID="TimeoutSeconds" ParameterType="int" Selector="$Config/TimeoutSeconds$"/>

    <OverrideableParameter ID="ConnectionString" ParameterType="string" Selector="$Config/ConnectionString$"/>

  </OverrideableParameters>

  <ModuleImplementation Isolation="Any">

    <Managed>

      <Assembly>Microsoft.SQLServer.Core.Module.Helper.Assembly</Assembly>

      <Type>Microsoft.SQLServer.Core.Module.Helper.Tasks.TestConnection</Type>

    </Managed>

  </ModuleImplementation>

  <OutputType>System!System.PropertyBagData</OutputType>

  <InputType>System!System.BaseData</InputType>

</WriteActionModuleType>