JobServer.MaximumJobHistoryRows-Eigenschaft
Gets or sets the maximum number of history rows retained per job.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)> _
Public Property MaximumJobHistoryRows As Integer
Get
Set
'Usage
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)
Eigenschaftswert
Typ: System.Int32
An Int32 value that specifies the maximum number of history rows retained per job.
Beispiele
Automatisierte Administrationstasks (SQL Server-Agent)
Siehe auch
Verweis
Microsoft.SqlServer.Management.Smo.Agent-Namespace
Andere Ressourcen
Planen von automatischen, administrativen Tasks im SQL Server-Agent
Gespeicherte Prozeduren des SQL Server-Agents (Transact-SQL)