Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Gets or sets the operator that receives notification by e-mail when the job finishes execution.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public Property OperatorToEmail As String
Get
Set
'Usage
Dim instance As Job
Dim value As String
value = instance.OperatorToEmail
instance.OperatorToEmail = value
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public string OperatorToEmail { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property String^ OperatorToEmail {
String^ get ();
void set (String^ value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member OperatorToEmail : string with get, set
function get OperatorToEmail () : String
function set OperatorToEmail (value : String)
Property Value
Type: System.String
A String value that specifies the operator that receives e-mail notification when the job finishes.
Examples
The following code example creates a job and specifies an e-mail address that receives notification when the job is completed.
C#
Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.Create();
jb.OperatorToEmail = "OperatorName";
PowerShell
$srv = new-object Microsoft.SqlServer.Management.Smo.Server("(local)")
$jb = new-object Microsoft.SqlServer.Management.Smo.Agent.Job($srv.JobServer, "Test Job")
$jb.Create()
$jb.EmailLevel =[Microsoft.SqlServer.Management.Smo.Agent.CompletionAction]::Always
$jb.OperatorToEmail = "OperatorName"
See Also
Reference
Microsoft.SqlServer.Management.Smo.Agent Namespace
Other Resources
Automated Administration Tasks (SQL Server Agent)
Scheduling Automatic Administrative Tasks in SQL Server Agent