Home
  •  

MSSQL: 泛型模板种子测试连接任务写入操作

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

模板种子测试连接任务写入操作

Element properties:

TypeWriteActionModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
InputTypeSystem.BaseData
OutputTypeSystem.PropertyBagData

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
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="MachineName" type="xsd:string"/>

    <xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="InstanceName" 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="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="ConnectionString" type="xsd:string"/>

    <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="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>