Post reply

Can we send Job Notification to two seperate "Operators"

  • October 4, 2005 at 11:23 am

    #89187

    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

    #594982

    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

    #595010

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 4, 2005 at 5:15 pm

    #595032

    Thanks for the help "yaweah" and "Lowell". This definitely helps.

  • October 5, 2005 at 3:33 am

    #595090

    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