Propriedade do RDL JobServer.MaximumJobHistoryRows
Gets or sets the maximum number of history rows retained per job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (em Microsoft.SqlServer.Smo.dll)
Sintaxe
'Declaração
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property MaximumJobHistoryRows As Integer
Get
Set
'Uso
Dim instance As JobServer
Dim value As Integer
value = instance.MaximumJobHistoryRows
instance.MaximumJobHistoryRows = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)]
public int MaximumJobHistoryRows { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Standalone|SfcPropertyFlags::SqlAzureDatabase)]
public:
property int MaximumJobHistoryRows {
int get ();
void set (int value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Standalone|SfcPropertyFlags.SqlAzureDatabase)>]
member MaximumJobHistoryRows : int with get, set
function get MaximumJobHistoryRows () : int
function set MaximumJobHistoryRows (value : int)
Valor da propriedade
Tipo: System.Int32
An Int32 value that specifies the maximum number of history rows retained per job.
Exemplos
Tarefas de administração automatizadas (SQL Server Agent)
Consulte também
Referência
Namespace Microsoft.SqlServer.Management.Smo.Agent
Outros recursos
Agendando tarefas administrativas automáticas no SQL Server Agent
Procedimentos armazenados do SQL Server Agent (Transact-SQL)