Results 1 to 4 of 4

Thread: Multiple e-mail notification

  1. 02-08-2001, 06:18 PM #1
    Sheldon Marumoto Guest

    Multiple e-mail notification


    Is there a way for an automated job to e-mail or net send to multiple locations on failure or completion?
    Reply With Quote Reply With Quote
  2. 02-08-2001, 06:44 PM #2
    Dallas Guest

    Multiple e-mail notification (reply)


    I had this problem and the only work around that I found was to have my MS Exchange Admin create a shared mailbox for the DBAs and the developers so that we could reference which ever was appropriate for the SQL Agent Mail notification. I don't know as far as Netsend though.

    ------------
    Sheldon Marumoto at 2/8/01 6:18:49 PM


    Is there a way for an automated job to e-mail or net send to multiple locations on failure or completion?
    Reply With Quote Reply With Quote
  3. 02-09-2001, 03:30 AM #3
    Phil McCormack Guest

    Multiple e-mail notification (reply)

    How about setting up a gloabl group under Exchange then setting up an operator under SQL which references this global group.



    ------------
    Dallas at 2/8/01 6:44:14 PM


    I had this problem and the only work around that I found was to have my MS Exchange Admin create a shared mailbox for the DBAs and the developers so that we could reference which ever was appropriate for the SQL Agent Mail notification. I don't know as far as Netsend though.

    ------------
    Sheldon Marumoto at 2/8/01 6:18:49 PM


    Is there a way for an automated job to e-mail or net send to multiple locations on failure or completion?
    Reply With Quote Reply With Quote
  4. 02-09-2001, 02:20 PM #4
    Sheldon Marumoto Guest

    Multiple e-mail notification (reply)

    I figured it out. I set up a custom error message and then pointed an alert at it. The alert allows for multiple e-mail, pager and net send messages. Then, in my job, I just RAISERROR my custom error, and presto! Of course, I have to complete with success AND failure on that one or the job fails. I guess you can't have it all!


    ------------
    Phil McCormack at 2/9/01 3:30:42 AM

    How about setting up a gloabl group under Exchange then setting up an operator under SQL which references this global group.



    ------------
    Dallas at 2/8/01 6:44:14 PM


    I had this problem and the only work around that I found was to have my MS Exchange Admin create a shared mailbox for the DBAs and the developers so that we could reference which ever was appropriate for the SQL Agent Mail notification. I don't know as far as Netsend though.

    ------------
    Sheldon Marumoto at 2/8/01 6:18:49 PM


    Is there a way for an automated job to e-mail or net send to multiple locations on failure or completion?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules