Udostępnij za pośrednictwem


Właściwość JobServer

Pobiera SQL Server Agent skojarzone wystąpienie SQL Server.

Przestrzeń nazw:  Microsoft.SqlServer.Management.Smo
Zestaw:  Microsoft.SqlServer.Smo (w Microsoft.SqlServer.Smo.dll)

Syntax

'Deklaracja
<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)> _
Public ReadOnly Property JobServer As JobServer
    Get
'Użycie
Dim instance As Server
Dim value As JobServer

value = instance.JobServer
[SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)]
public JobServer JobServer { get; }
[SfcObjectAttribute(SfcObjectRelationship::Object, SfcObjectCardinality::One)]
public:
property JobServer^ JobServer {
    JobServer^ get ();
}
[<SfcObjectAttribute(SfcObjectRelationship.Object, SfcObjectCardinality.One)>]
member JobServer : JobServer
function get JobServer () : JobServer

Wartość właściwości

Typ: Microsoft.SqlServer.Management.Smo.Agent. . :: . .JobServer
A JobServer obiekt, który określa SQL Server Agent skojarzone wystąpienie SQL Server.

Uwagi

JobServer Reprezentuje obiekt SQL Server agenta.Można użyć JobServer obiektu odwołania SQL Server zadania agenta, operatory i alerty.SQL ServerUstawienia Agenta można przeglądać lub modyfikować za pomocą JobServer obiektu.

Przykłady

Visual Basic

'Connect to the local, default instance of SQL Server.
Dim srv As Server
srv = New Server
'Define an Alert object variable by supplying the SQL Agent and the name arguments in the constructor.
Dim al As Alert
al = New Alert(srv.JobServer, "Test_Alert")
'Specify the performance condition string to define the alert.
al.PerformanceCondition = "SQLServer:General Statistics|User Connections||>|3"
'Create the alert on the SQL Agent.
al.Create()
'Define an Operator object variable by supplying the SQL Agent and the name arguments in the constructor.
Dim op As [Operator]
op = New [Operator](srv.JobServer, "Test_Operator")
'Set the net send address.
op.NetSendAddress = "NetworkPC"
'Create the operator on the SQL Agent.
op.Create()
'Run the AddNotification method to specify the operator is notified when the alert is raised.
al.AddNotification("Test_Operator", NotifyMethods.NetSend)

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)