MergeSubscriberMonitor.GetSessionsSummary Method (Int32)

Articolo
12/15/2008

Returns summary information for Merge Agent sessions that have occurred in the past number of hours specified.

Spazio dei nomi: Microsoft.SqlServer.Replication
Assembly : Microsoft.SqlServer.Rmo (in microsoft.sqlserver.rmo.dll)

Sintassi

'Dichiarazione
Public Function GetSessionsSummary ( _
    hours As Integer _
) As MergeSessionSummary()

public MergeSessionSummary[] GetSessionsSummary (
    int hours
)

public:
array<MergeSessionSummary^>^ GetSessionsSummary (
    int hours
)

public MergeSessionSummary[] GetSessionsSummary (
    int hours
)

public function GetSessionsSummary (
    hours : int
) : MergeSessionSummary[]

Parametri

hours
The past number hours for which to return session information.

Valore restituito

An array of MergeSessionSummary objects.

Eccezioni

Tipo di eccezione	Condizione
ArgumentException	Occurs when one of the properties that defines the subscription is null or not specified.

Osservazioni

Call the GetSessionsSummary method instead of GetSessionsSummary(Int32) to return all available sessions, up to a maximum of five sessions.

Calling the GetSessionsSummary(Int32) method is equivalent to executing sp_replmonitorhelpmergesession (Transact-SQL) at the Subscriber.

The GetSessionsSummary(Int32) method can be executed by members of the db_owner or replmonitor fixed database roles in the distribution database, when connected to the Distributor, or in the subscription database, when connected to the Subscriber.

This namespace, class, or member is supported only in version 2.0 of the Microsoft .NET Framework.

Thread Safety

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

Piattaforme

Piattaforme di sviluppo

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Piattaforme di destinazione

Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.

Vedere anche

Riferimento

MergeSubscriberMonitor Class
MergeSubscriberMonitor Members
Microsoft.SqlServer.Replication Namespace

Altre risorse

How to: Programmatically Monitor Replication (RMO Programming)
Subscriber Monitor Sample
How to: Programmatically Monitor Replication (RMO Programming)
Subscriber Monitor Sample

Condividi tramite