Share via


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

JobServer Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Scheduling Automatic Administrative Tasks in SQL Server Agent

SQL Server Agent Stored Procedures (Transact-SQL)