JobServer.MaximumJobHistoryRows Property
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)
Property Value
Type: System.Int32
An Int32 value that specifies the maximum number of history rows retained per job.
Examples
Automated Administration Tasks (SQL Server Agent)
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Scheduling Automatic Administrative Tasks in SQL Server Agent