مشاركة عبر


JobHistoryFilter.SqlMessageID Property

Gets or sets the job filter constraint that restricts the values returned by the JobServer object's EnumJobHistory method to jobs that have generated the specified message during execution.

Namespace:  Microsoft.SqlServer.Management.Smo.Agent
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

Syntax

'Declaration
Public Property SqlMessageID As Integer 
    Get 
    Set
'Usage
Dim instance As JobHistoryFilter 
Dim value As Integer 

value = instance.SqlMessageID

instance.SqlMessageID = value
public int SqlMessageID { get; set; }
public:
property int SqlMessageID {
    int get ();
    void set (int value);
}
member SqlMessageID : int with get, set
function get SqlMessageID () : int 
function set SqlMessageID (value : int)

Property Value

Type: System.Int32
An Int32 value that specifies the ID value of the message that was generated during the execution of the job.

Remarks

The job history filter can be used to restrict the list returned by the JobServer object's EnumJobHistory method to jobs.

Examples

Scheduling Automatic Administrative Tasks in SQL Server Agent

See Also

Reference

JobHistoryFilter Class

Microsoft.SqlServer.Management.Smo.Agent Namespace

Other Resources

Automated Administration Tasks (SQL Server Agent)