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 completion action that determines whether to net-send a notification to an operator when the job finishes execution.
Namespace: Microsoft.SqlServer.Management.Smo.Agent
Assembly: Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.Standalone)> _
Public Property NetSendLevel As CompletionAction
Get
Set
'Usage
Dim instance As Job
Dim value As CompletionAction
value = instance.NetSendLevel
instance.NetSendLevel = value
[SfcPropertyAttribute(SfcPropertyFlags.Standalone)]
public CompletionAction NetSendLevel { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::Standalone)]
public:
property CompletionAction NetSendLevel {
CompletionAction get ();
void set (CompletionAction value);
}
[<SfcPropertyAttribute(SfcPropertyFlags.Standalone)>]
member NetSendLevel : CompletionAction with get, set
function get NetSendLevel () : CompletionAction
function set NetSendLevel (value : CompletionAction)
Property Value
Type: Microsoft.SqlServer.Management.Smo.Agent.CompletionAction
A CompletionAction value that specifies whether to net-send a notification to an operator.
Remarks
If directed, Microsoft SQL Server Agent can net-send a notification when execution succeeds or fails. Net-send notifications can also be sent regardless of success or failure of the job. By default, net-send notifications are not sent when execution finishes.
Examples
The following code example creates a job and specifies that a notification is always net-sent when the job has finished execution.
C#
Server srv = new Server("(local)");
Job jb = new Job(srv.JobServer, "Test Job");
jb.Create();
jb.NetSendLevel = CompletionAction.Always
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.NetSendlevel = [Microsoft.SqlServer.Management.Smo.Agent.CompletionAction]::Always
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