send email notification using DBmail

  • hi guys..

    i know how to send an email notification when any job fail to particular operator..

    but if i have multiple operator, how can i send an email notification to all operator at once once job fails or succeed w/o creating group email add.

    please let me know asap...

  • When you create the operator, you can supply a list of email addresses, each separated by a comma. Set up your addresses there, and use that operator as your notification point.

    Karl Lambert
    SQL Server Database Administration
    Business Intelligence Development

  • Create an Operator that has multiple people in it.

    Operator: "Job Alert Group"

    Email Name: Joe@abc.com; Mary@abc.com; Mike@abd.com

  • for that do i need to setup database mail profile or not?

  • You would just use the profile that you were using before. All you need to do is edit the operator that you are sending the mail to now, and update it with the multiple addresses. You should not need to create a new mail profile for that.

    Karl Lambert
    SQL Server Database Administration
    Business Intelligence Development

  • between email addresses i have to put ; or , ?

  • ok i got the answer ; but does it req. to restart sql server agent?

  • It would be a semi-colon. I misspoke earlier when I said comma. Use the ;

    Karl Lambert
    SQL Server Database Administration
    Business Intelligence Development

  • san-1015392 (2/18/2010)


    ok i got the answer ; but does it req. to restart sql server agent?

    Not to work with operators, assuming you already have mail working.

    If you are setting up mail for the first time, I think it requires a restart (not sure)

  • no i did not setup dbmail, i setup only operator notification..in my testing machine it works fine after restart of sql server agent..but in other server does it req. or not for only operator notification? i m not talking abt dbmail at any choice..

Viewing 10 posts - 1 through 9 (of 9 total)

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