February 18, 2010 at 11:36 am
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...
February 18, 2010 at 11:46 am
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
February 18, 2010 at 11:47 am
Create an Operator that has multiple people in it.
Operator: "Job Alert Group"
Email Name: Joe@abc.com; Mary@abc.com; Mike@abd.com
February 18, 2010 at 11:49 am
for that do i need to setup database mail profile or not?
February 18, 2010 at 11:56 am
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
February 18, 2010 at 11:58 am
between email addresses i have to put ; or , ?
February 18, 2010 at 12:00 pm
ok i got the answer ; but does it req. to restart sql server agent?
February 18, 2010 at 12:01 pm
It would be a semi-colon. I misspoke earlier when I said comma. Use the ;
Karl Lambert
SQL Server Database Administration
Business Intelligence Development
February 18, 2010 at 12:17 pm
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)
February 18, 2010 at 12:28 pm
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