Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

PublicationMonitor Class

Monitors a publication.

System.Object
  Microsoft.SqlServer.Replication.ReplicationObject
    Microsoft.SqlServer.Replication.PublicationMonitor

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
public sealed class PublicationMonitor : ReplicationObject

The PublicationMonitor type exposes the following members.

  NameDescription
Public methodPublicationMonitor()Creates a new instance of the PublicationMonitor class.
Public methodPublicationMonitor(String, String, String, String, ServerConnection)Creates a new instance of the PublicationMonitor class with the specified name, distribution database, Publisher, publication database, and connection to the Distributor.
Top
  NameDescription
Public propertyCachePropertyChangesGets or sets whether to cache changes made to the replication properties or to apply them immediately. (Inherited from ReplicationObject.)
Public propertyCacheRefreshPolicyInfrastructure. Gets or sets the monitor cache refresh policy.
Public propertyConnectionContextGets or sets the connection to an instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public propertyDescriptionGets the textual description of the publication.
Public propertyDistributionDBNameGets the name of the distribution database used by the publication.
Public propertyExcludeAnonymousSubscriptionsGets or sets whether anonymous subscriptions are excluded from or included in the monitor results.
Public propertyIsExistingObjectGets whether the object exists on the server or not. (Inherited from ReplicationObject.)
Public propertyNameGets or sets the name of the monitored publication.
Public propertyPublicationDBNameGets or sets the name of the publication database.
Public propertyPublisherNameGets or sets the name of the Publisher.
Public propertyQueueReaderAgentNameGets the queue reader agent name.
Public propertySqlServerNameGets the name of the Microsoft SQL Server instance to which this object is connected. (Inherited from ReplicationObject.)
Public propertyStatusGets the status of the publication.
Public propertyStatusAndWarningGets the status and warnings of the referenced publication on the Distributor, including all of the agents associated for the publication.
Public propertyTypeGets the type of replication in which the publication participates.
Public propertyUserDataGets or sets an object property that allows users to attach their own data to the object. (Inherited from ReplicationObject.)
Top
  NameDescription
Public methodChangeMonitorThresholdChanges the monitoring threshold metric for a publication.
Public methodCleanUpTracerTokenHistory(DateTime)Removes all metadata for tracer tokens older than the specified date from a database published using transactional replication.
Public methodCleanUpTracerTokenHistory(Int32)Removes metadata for a specific tracer token from a database published using transactional replication.
Public methodCommitPropertyChangesSends all the cached property change statements to the instance of Microsoft SQL Server. (Inherited from ReplicationObject.)
Public methodDecoupleDecouples the referenced replication object from the server. (Inherited from ReplicationObject.)
Public methodEnumErrorRecordsReturns information about errors associated with a specified error ID that occurred during a synchronization session.
Public methodEnumLogReaderAgentReturns information for the Log Reader Agent job used by the monitored publication.
Public methodEnumMonitorThresholdsReturns the replication monitor thresholds defined for this publication.
Public methodEnumQueueReaderAgentReturns information for the Queue Reader Agent job used by the monitored publication.
Public methodEnumSnapshotAgentReturns information for the Snapshot Agent job used by the monitored publication.
Public methodEnumSubscriptionsReturns information on subscriptions that are subscribed to the monitored publication.
Public methodEnumSubscriptions2Returns additional information on subscriptions that are subscribed to the monitored publication.
Public methodEnumTracerTokenHistoryReturns Subscriber latency information for a single tracer token record inserted into a monitored transactional publication.
Public methodEnumTracerTokensReturns all tracer tokens that have been inserted into the monitored transactional publication.
Public methodEquals (Inherited from Object.)
Public methodGetHashCode (Inherited from Object.)
Public methodGetType (Inherited from Object.)
Public methodLoadLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodLoadPropertiesLoads the properties of an existing object from the server. (Inherited from ReplicationObject.)
Public methodRefreshReloads the properties of the object. (Inherited from ReplicationObject.)
Public methodToString (Inherited from Object.)
Public methodTransPendingCommandInfoReturns information about pending commands for a subscription.
Top

An exception will be thrown if the specified Distributor, distribution database, and Publisher are not configured for replication.

PublicationMonitor requires a connection to the Distributor.

Thread Safety

Any public static (Shared in Microsoft Visual Basic) members of this type are safe for multithreaded operations. Any instance members are not guaranteed to be thread safe.

Any public static (Shared in Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.