DistributionDatabase.HistoryCleanupTaskName Property
Gets the name of the SQL Server Agent job that is responsible for cleaning up replication history tables.
Namespace: Microsoft.SqlServer.Replication
Assembly: Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)
Syntax
'Declaration
Public ReadOnly Property HistoryCleanupTaskName As String
Get
'Usage
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
Property Value
Type: System.String
A String value.
Remarks
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.