DistributionDatabase.DistributionCleanupTaskName Property

Definition

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

public:
 property System::String ^ DistributionCleanupTaskName { System::String ^ get(); };
public string DistributionCleanupTaskName { get; }
member this.DistributionCleanupTaskName : string
Public ReadOnly Property DistributionCleanupTaskName As String

Property Value

A String value.

Remarks

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.

Applies to