Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
thegoofyone
Starting Member
3 Posts |
 Posted - 2006-05-16 : 18:42:11
|
Hi everyone,I'm a newbie to SQL Server.I was wondering if it is possible to have 2 different email notification lists for 2 different jobs?Example:Email Notification..................Job-------------------................----------PersonA............................Backup JobPersonB............................Restore JobI'm wondering if there is a bug here because when I change the email notification list for one job, this change affects ALL the jobs of that instance!!!PS I have SS2000 + SP4Thanks in advance,TheGoofyOne  |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-16 : 18:43:30
|
| So did you setup PersonA and PersonB as operators?Tara Kizeraka tduggan |
 |
|
|
thegoofyone
Starting Member
3 Posts |
Posted - 2006-05-16 : 18:45:35
|
| Yes, PersonA and PersonB are two different operators. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-16 : 18:49:35
|
| I am not able to reproduce your problem. I have SP4 as well. I setup two different operators then modified two existing jobs to notify the different operators. Nothing changed.Tara Kizeraka tduggan |
|
|
|
thegoofyone
Starting Member
3 Posts |
Posted - 2006-05-17 : 11:11:37
|
| Tkizer,Yes, you are right. My mistake. I know what my problem is..when I add an extra email onto the email notification, this affects ALL jobs.I have another question, is it possible to have more than one operator in an email notification?Thanks for all your help,TheGoofyOne |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-05-17 : 11:18:16
|
| I'm not sure about that. I've always used an e-mail group when I wanted to notify multiple DBAs. So I had one operator point to an e-mail group that had multiple members.Tara Kizeraka tduggan |
|
|
|
|
|
|
Email Notification Problem