Post reply

Difference between Operators and Mail profiles.

  • March 5, 2012 at 3:38 am

    #269421

    Hi,

    Had a little doubt,

    Database mail needs to be configured to make the profiles and accounts , right ? something similar to what our outlook does .

    And for sending out alerts through SQL Agent we need to create operators ? Like if a job fails then notify operator DBA .

    So , my question is , do we need to configure database mail just for sending out alerts ? Wont just creating an operator suffice ?

  • March 5, 2012 at 3:50 am

    #1454710

    Database mail is configure to let sql server know which account to use to end emails

    The operator is used to configure the to list as well as it supports other types of alters such as net send etc

    The alerts and operators are all part of the sql agent while DB Mail is part of the sql server service.

    Jayanth Kurup[/url]

  • March 5, 2012 at 4:07 am

    #1454714

    Right .

    So that means i need not configure database mail to send out alerts for agent jobs , right ?

    Am i going in the wrong direction here ? Or my understanding is correct ?

  • March 5, 2012 at 4:33 am

    #1454723

    in order to send out email alerts you have no choice but configure DB Mail.

    The only time you can use the operator without setting up DB mail is if you plan to alter the user via net send or pager .

    Jayanth Kurup[/url]

  • March 5, 2012 at 5:09 am

    #1454734

    Thanks 🙂

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply