SqlAgentFailsafe

SqlAgentFailsafe

Parameters

Parameter	Attribute	DataType	Description	Allowed Values
Name	Required	String	The name of the SQL Agent Failsafe Operator.
Ensure	Write	String	Specifies if the SQL Agent Failsafe Operator should be present or absent. Default is Present.	Present, Absent
ServerName	Write	String	The host name of the SQL Server to be configured. Default is $env:COMPUTERNAME.
InstanceName	Key	String	The name of the SQL instance to be configured.
NotificationMethod	Write	String	The method of notification for the Failsafe Operator.	None, NotifyEmail, Pager, NetSend, NotifyAll

Description

The SqlAgentAlert DSC resource is used to add/remove SQL Agent Alerts. The resource can also update the severity or message id.

Requirements

• Target machine must be running Windows Server 2012 or later.
• Target machine must be running SQL Server Database Engine 2012 or later.

Known issues

All issues are not listed here, see here for all open issues.

Examples

Example 1

This example shows how to ensure that the SQL Agent Failsafe Operator 'FailsafeOp' exists with the correct Notification.

Configuration Example
{
    Import-DscResource -ModuleName 'SqlServerDsc'

    node localhost
    {
        SqlAgentFailsafe 'Add_FailsafeOp'
        {
            Ensure             = 'Present'
            Name               = 'FailsafeOp'
            ServerName         = 'TestServer'
            InstanceName       = 'MSSQLServer'
            NotificationMethod = 'NotifyEmail'
        }
    }
}

Example 2

This example shows how to ensure that the SQL Agent failsafe operator FailsafeOp does not exist.

Configuration Example
{
    Import-DscResource -ModuleName 'SqlServerDsc'

    node localhost
    {
        SqlAgentFailsafe 'Remove_FailsafeOp'
        {
            Ensure       = 'Absent'
            Name         = 'FailsafeOp'
            ServerName   = 'TestServer'
            InstanceName = 'MSSQLServer'
        }
    }
}