SqlServerDsc

13.2.0.0

Examples/Resources/SqlAgentAlert/1-AddAlert.ps1

                                <#

    .EXAMPLE

        This example shows how to ensure that the SQL Agent Alert

        Sev17 exists with the correct severity level.

    .EXAMPLE

        This example shows how to ensure that the SQL Agent Alert

        Msg825 exists with the correct message id.

#>

Configuration Example

{

    Import-DscResource -ModuleName SqlServerDsc

    node localhost {

        SqlAgentAlert Add_Sev17 {

            Ensure               = 'Present'

            Name                 = 'Sev17'

            ServerName           = 'TestServer'

            InstanceName         = 'MSSQLServer'

            Severity             = '17'

        }

        SqlAgentAlert Add_Msg825 {

            Ensure               = 'Present'

            Name                 = 'Msg825'

            ServerName           = 'TestServer'

            InstanceName         = 'MSSQLServer'

            MessageId            = '825'

        }

    }

}