DistributionDatabase.HistoryCleanupTaskName 属性

Gets the name of the SQL Server Agent job that is responsible for cleaning up replication history tables.

命名空间:  Microsoft.SqlServer.Replication
程序集:  Microsoft.SqlServer.Rmo(在 Microsoft.SqlServer.Rmo.dll 中)

语法

声明
Public ReadOnly Property HistoryCleanupTaskName As String 
    Get
用法
Dim instance As DistributionDatabase 
Dim value As String 

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

属性值

类型:System.String
A String value.

注释

The HistoryCleanupTaskName property can only be retrieved by members of the db_owner or replmonitor fixed database role on the distribution database, by users in the publication access list (PAL) of a publication using the distribution database, or by users with SELECT permission on the MSdistributiondbs system table in the distribution database.

Retrieving the HistoryCleanupTaskName property is equivalent to executing sp_helpdistributiondb.

请参阅

参考

DistributionDatabase 类

Microsoft.SqlServer.Replication 命名空间