MSSQL on Windows 复制: 分发数据库可用性数据源
Microsoft.SQLServer.Replication.Windows.DataSource.DistributorAvailabilityFromSubscriber (DataSourceModuleType)
分发数据库的可用性数据源。
Element properties:
Member Modules:
Overrideable Parameters:
Source Code:
<DataSourceModuleType ID="Microsoft.SQLServer.Replication.Windows.DataSource.DistributorAvailabilityFromSubscriber" Accessibility="Internal" Batching="false">
<Configuration>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Distributor" 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="Domain" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="User" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Pass" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Transport" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Prefix" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="Port" type="xsd:integer"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="DatabaseNames" type="xsd:string"/>
<xsd:element xmlns:xsd="http://www.w3.org/2001/XMLSchema" name="CredSspEnabled" type="xsd:boolean"/>
<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="SqlTimeoutSeconds" type="xsd:integer"/>
<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="Subscriber" ParameterType="string" Selector="$Config/Subscriber$"/>
<OverrideableParameter ID="Transport" ParameterType="string" Selector="$Config/Transport$"/>
<OverrideableParameter ID="Prefix" ParameterType="string" Selector="$Config/Prefix$"/>
<OverrideableParameter ID="Port" ParameterType="int" Selector="$Config/Port$"/>
<OverrideableParameter ID="DatabaseNames" ParameterType="string" Selector="$Config/DatabaseNames$"/>
<OverrideableParameter ID="CredSspEnabled" ParameterType="bool" Selector="$Config/CredSspEnabled$"/>
<OverrideableParameter ID="IntervalSeconds" ParameterType="int" Selector="$Config/IntervalSeconds$"/>
<OverrideableParameter ID="SqlTimeoutSeconds" ParameterType="int" Selector="$Config/SqlTimeoutSeconds$"/>
<OverrideableParameter ID="SyncTime" ParameterType="string" Selector="$Config/SyncTime$"/>
<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.Replication.Windows.ProbeAction.DistributorAvailabilityFromSubscriber">
<Distributor>$Config/Distributor$</Distributor>
<Subscriber>$Config/Subscriber$</Subscriber>
<DatabaseNames>$Config/DatabaseNames$</DatabaseNames>
<Domain>$Config/Domain$</Domain>
<User>$Config/User$</User>
<Pass>$Config/Pass$</Pass>
<Transport>$Config/Transport$</Transport>
<Port>$Config/Port$</Port>
<Prefix>$Config/Prefix$</Prefix>
<CredSspEnabled>$Config/CredSspEnabled$</CredSspEnabled>
<SqlTimeoutSeconds>$Config/SqlTimeoutSeconds$</SqlTimeoutSeconds>
<TimeoutSeconds>$Config/TimeoutSeconds$</TimeoutSeconds>
<Publisher>SQLReplicationMonitoringWindows</Publisher>
<ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>
</ProbeAction>
</MemberModules>
<Composition>
<Node ID="Probe">
<Node ID="Trigger"/>
</Node>
</Composition>
</Composite>
</ModuleImplementation>
<OutputType>System!System.PropertyBagData</OutputType>
</DataSourceModuleType>