Server.JobServer Property

 

Gets the SQL Server Agent associated with the instance of SQL Server.

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

No code example is currently available or this language may not be supported.

Property Value

Type: Microsoft.SqlServer.Management.Smo.Agent.JobServer

A JobServer object that specifies the SQL Server Agent associated with the instance of SQL Server.

The JobServer object represents the SQL Server Agent. You can use the JobServer object to reference the SQL Server Agent jobs, operators, and alerts. SQL Server Agent settings can be viewed or modified by using the JobServer object.

Visual Basic

PowerShell

$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$al = new-object Microsoft.SqlServer.Management.Smo.Agent.Alert($srv.JobServer, "Test Alert")
$al.PerformanceCondition = "SQLServer:General Statistics|User Connections||>|3"
$al.Create()
$op = new-object Microsoft.SqlServer.Management.Smo.Agent.Operator($srv.JobServer, "Test Operator")
$op.NetSendAddress = "NetworkPC"
$op.Create()
$al.AddNotification("Test Operator", [Microsoft.SqlServer.Management.Smo.Agent.NotifyMethods]::NetSend)
Return to top
Show: