共用方式為


DistributionDatabase.DistributionCleanupTaskName 屬性

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

命名空間:  Microsoft.SqlServer.Replication
組件:  Microsoft.SqlServer.Rmo (在 Microsoft.SqlServer.Rmo.dll 中)

語法

'宣告
Public ReadOnly Property DistributionCleanupTaskName As String 
    Get
'用途
Dim instance As DistributionDatabase 
Dim value As String 

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

屬性值

型別:System.String
A String value.

備註

The DistributionCleanupTaskName 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 DistributionCleanupTaskName property is equivalent to executing sp_helpdistributiondb.

請參閱

參考

DistributionDatabase 類別

Microsoft.SqlServer.Replication 命名空間