DistributionDatabase.DistributionCleanupTaskName Propiedad
Gets the name of the SQL Server Agent job that is responsible for cleaning up the replication tables in the distribution.
Espacio de nombres: Microsoft.SqlServer.Replication
Ensamblado: Microsoft.SqlServer.Rmo (en Microsoft.SqlServer.Rmo.dll)
Sintaxis
'Declaración
Public ReadOnly Property DistributionCleanupTaskName As String
Get
'Uso
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
Valor de la propiedad
Tipo: System.String
A String value.
Comentarios
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.