Home
  •  

散發者: 擱置命令資料來源

Microsoft.SQLServer.2014.Replication.DataSource.DistributorPendingCmdsMonitor (DataSourceModuleType)

散發者資料來源之散發資料庫中的擱置命令

Element properties:

TypeDataSourceModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
OutputTypeSystem.PropertyBagData

Member Modules:

ID Module Type TypeId RunAs 
Trigger DataSource System.Scheduler Default
Probe ProbeAction Microsoft.SQLServer.2014.Replication.ProbeAction.DistributorPendingCmdsMonitor Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$間隔 (秒)執行工作流程的週期性時間間隔 (秒)。
SyncTimestring$Config/SyncTime$同步處理時間同步處理時間
SqlTimeoutint$Config/SqlTimeout$資料庫連線的逾時 (秒)若工作流程無法在指定的期限之內存取資料庫，將會失敗並登錄一則事件。
TimeoutSecondsint$Config/TimeoutSeconds$逾時 (秒)指定工作流程在關閉並標記為失敗前所能執行的時間。

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2014.Replication.DataSource.DistributorPendingCmdsMonitor" Accessibility="Internal" Batching="false">

  <Configuration>

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

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

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

  </Configuration>

  <OverrideableParameters>

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

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

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

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

  </OverrideableParameters>

  <ModuleImplementation>

    <Composite>

      <MemberModules>

        <DataSource ID="Trigger" TypeID="System!System.Scheduler">

          <Scheduler>

            <SimpleReccuringSchedule>

              <Interval>$Config/IntervalSeconds$</Interval>

              <SyncTime>$Config/SyncTime$</SyncTime>

            </SimpleReccuringSchedule>

            <ExcludeDates/>

          </Scheduler>

        </DataSource>

        <ProbeAction ID="Probe" TypeID="Microsoft.SQLServer.2014.Replication.ProbeAction.DistributorPendingCmdsMonitor">

          <SqlTimeout>$Config/SqlTimeout$</SqlTimeout>

          <ConnectionString>$Config/ConnectionString$</ConnectionString>

          <Publisher>Replication2014</Publisher>

          <TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>

        </ProbeAction>

      </MemberModules>

      <Composition>

        <Node ID="Probe">

          <Node ID="Trigger"/>

        </Node>

      </Composition>

    </Composite>

  </ModuleImplementation>

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

</DataSourceModuleType>