Поделиться через


Свойство PullSubscription.LastAgentDateTime

Gets the date and time when the subscription was last synchronized.

Пространство имен:  Microsoft.SqlServer.Replication
Сборка:  Microsoft.SqlServer.Rmo (в Microsoft.SqlServer.Rmo.dll)

Синтаксис

'Декларация
Public ReadOnly Property LastAgentDateTime As String 
    Get
'Применение
Dim instance As PullSubscription 
Dim value As String 

value = instance.LastAgentDateTime
public string LastAgentDateTime { get; }
public:
property String^ LastAgentDateTime {
    String^ get ();
}
member LastAgentDateTime : string
function get LastAgentDateTime () : String

Значение свойства

Тип: System.String
A String value that represents a date and time.

Замечания

The date and time data is formatted as YYYYMMDD hh:mm:ss.fff, where

  • YYYY represents the year in four digits.

  • MM represents the month in two digits (zero padded).

  • DD represents the day of the month in two digits (zero padded).

  • hh represents the hour using two digits, a twenty-four hour clock (zero padded).

  • mm represents the minute in two digits (zero padded).

  • ss represents the second in two digits (zero padded).

  • fff represents the fractional part of the second in three digits.

For example, the value 20040121 18:12:00.000 is interpreted as 6:12 P.M., January 21, 2004.

The LastAgentDateTime property can only be retrieved by members of the sysadmin fixed server role at the Subscriber or by members of the db_owner fixed database role on the subscription database.

Retrieving the LastAgentDateTime property is equivalent to executing sp_helppullsubscription (Transact-SQL) or sp_helpmergepullsubscription (Transact-SQL).

См. также

Справочник

PullSubscription Класс

Пространство имен Microsoft.SqlServer.Replication