Datenquelle für ausstehende Befehle des Abonnements

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

Element properties:

TypeDataSourceModuleType
IsolationAny
AccessibilityInternal
RunAsDefault
OutputTypeSystem.PropertyBagData

Member Modules:

ID Module Type TypeId RunAs 
Trigger DataSource Microsoft.SQLServer.2014.Replication.DataSource.SubscriptionPendingCmdsMonitorCookdownDataSource Default
Probe ProbeAction Microsoft.SQLServer.2014.Replication.ProbeAction.PropertyBagMapperProbeAction Default
CD ConditionDetection System.ExpressionFilter Default

Overrideable Parameters:

IDParameterTypeSelectorDisplay NameDescription
IntervalSecondsint$Config/IntervalSeconds$Intervall (Sekunden)Das periodische Intervall in Sekunden, in dem der Workflow ausgeführt werden soll.
SyncTimestring$Config/SyncTime$SynchronisierungszeitSynchronisierungszeit
SqlTimeoutint$Config/SqlTimeout$Timeout (Sekunden)Timeout (Sekunden)

Source Code:

<DataSourceModuleType ID="Microsoft.SQLServer.2014.Replication.DataSource.SubscriptionPendingCmdsMonitor" 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="SubscriptionType" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="PublisherName" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Subscriber" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="PublisherDb" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="SubscriberDb" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Publication" 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"/>
</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$"/>
</OverrideableParameters>
<ModuleImplementation>
<Composite>
<MemberModules>
<DataSource ID="Trigger" TypeID="Microsoft.SQLServer.2014.Replication.DataSource.SubscriptionPendingCmdsMonitorCookdownDataSource">
<SqlTimeout>$Config/SqlTimeout$</SqlTimeout>
<ConnectionString>$Config/ConnectionString$</ConnectionString>
<Subscriber>$Config/Subscriber$</Subscriber>
<IntervalSeconds>$Config/IntervalSeconds$</IntervalSeconds>
<SyncTime>$Config/SyncTime$</SyncTime>
</DataSource>
<ProbeAction ID="Probe" TypeID="Microsoft.SQLServer.2014.Replication.ProbeAction.PropertyBagMapperProbeAction">
<Key>$Config/PublisherName$$Config/Subscriber$$Config/PublisherDb$$Config/SubscriberDb$$Config/Publication$</Key>
<PropertiesNameList>SubscriptionPendingCmds</PropertiesNameList>
<Separator/>
<Publisher>Replication2014</Publisher>
</ProbeAction>
<ConditionDetection ID="CD" TypeID="System!System.ExpressionFilter">
<Expression>
<Exists>
<ValueExpression>
<XPathQuery Type="String">Property[@Name='SubscriptionPendingCmds']</XPathQuery>
</ValueExpression>
</Exists>
</Expression>
</ConditionDetection>
</MemberModules>
<Composition>
<Node ID="CD">
<Node ID="Probe">
<Node ID="Trigger"/>
</Node>
</Node>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>System!System.PropertyBagData</OutputType>
</DataSourceModuleType>