• Note

    A common question about operators is how you can send alerts to multiple people. The way you do this is to use mail distribution lists through your email system, as SQL Server Agent will only send alerts to a single operator. You would therefore define the operator in SQL Server Agent as a distribution list, and everyone on the list will then receive the associated alerts.

    Or...you can create an operator consisting of multiple individuals. Just separate the email names with a semicolon. A MDL may be preferable but in some cases may not be an option.

    (in SQL2005 anyway)


    Cursors are useful if you don't know SQL