October 4, 2005 at 11:23 am
Can we send sql server job notification (emails) to two seperate operatos (for Ex "dba_on_call" and "backup_dba_on_call").
One alternate to do this will be to include the emails of both "dba_on_call" and "backup_dba_on_call" to the same operator but in this case every job notification that is sent to one email will also be sent to other email. We wanted only some jobs notification to go to both.
In the "job/Notification/Email-Operator" option the drop down lets me select only one operator.
Thanks for all the help.
October 4, 2005 at 2:04 pm
No you can't from what i know, but there is a work around. Create a new operator that contains email or Pager for both Operator1 and Operator2 like this DBA_Group(Emailpt1@Somewhere.com; <A href="mailtopt2@Nowhere.com">Opt2@Nowhere.com). Let me know if it is not clear.
October 4, 2005 at 3:14 pm
you could also solve this at the mailserver level...where a group called DBANotifications is created, and dba's are added to that group...then have the scheduled job send to the group rather than an individual;
it would also make administrtion easier, because onlt the DBA would edit the job to change the email...and if the DBA bolts, the emails continue going to the now ex-DBA until the new DBA gets around to reading and changing jobs;
Lowell
October 4, 2005 at 5:15 pm
Thanks for the help "yaweah" and "Lowell". This definitely helps.
October 5, 2005 at 3:33 am
You can also use the page operator drop down to put an email address in.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply