How do I net send a job notification to multiple operators?

21 Sep 2006 7:42 PM

paladinomichael

In the Notifications section of SQL Server Agent > Jobs, only one Net
send operator can be selected. Setting up an operator with multiple
semicolon delimited computer names as recommended in the following
thread did not work:
http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/ffe4448cff880915/ff21fe3879bd473d?lnk=st&q=sql+server+net+send+multiple+operators&rnum=1#ff21fe3879bd473d

Any other ideas? Thanks in advance.

21 Sep 2006 9:05 PM

Arnie Rowland

Set up a email distribution group, add all 'operators' to the email
distribution group, and register that 'group' as the operator.

--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc

Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous

<paladinomich***@gmail.com> wrote in message

Show quote

news:1158867764.150580.16490@i3g2000cwc.googlegroups.com...
> In the Notifications section of SQL Server Agent > Jobs, only one Net
> send operator can be selected. Setting up an operator with multiple
> semicolon delimited computer names as recommended in the following
> thread did not work:
> http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/ffe4448cff880915/ff21fe3879bd473d?lnk=st&q=sql+server+net+send+multiple+operators&rnum=1#ff21fe3879bd473d
>
> Any other ideas? Thanks in advance.
>

25 Sep 2006 1:34 PM

mjpalad

Thanks for your response, but I am trying to use "Net Send" operators
as I don't have the email ability setup. Any ideas how to do the same
thing with net send operators?

Arnie Rowland wrote:
Show quote

> Set up a email distribution group, add all 'operators' to the email
> distribution group, and register that 'group' as the operator.
>
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
>
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
>
>
> <paladinomich***@gmail.com> wrote in message
> news:1158867764.150580.16490@i3g2000cwc.googlegroups.com...
> > In the Notifications section of SQL Server Agent > Jobs, only one Net
> > send operator can be selected. Setting up an operator with multiple
> > semicolon delimited computer names as recommended in the following
> > thread did not work:
> > http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/ffe4448cff880915/ff21fe3879bd473d?lnk=st&q=sql+server+net+send+multiple+operators&rnum=1#ff21fe3879bd473d
> >
> > Any other ideas? Thanks in advance.
> >

28 Sep 2006 3:03 AM

Sue Hoegemeier

You can run a job that executes the netsend from the command
line to each operator. So you have a Operating System
Command (CmdExec) job step to execute:
net send operator1 SomeMessage
net send operator2 SomeMessage

-Sue

On 25 Sep 2006 06:34:55 -0700, "mjpalad"
<paladinomich***@gmail.com> wrote:

Show quote

>Thanks for your response, but I am trying to use "Net Send" operators
>as I don't have the email ability setup. Any ideas how to do the same
>thing with net send operators?
>
>Arnie Rowland wrote:
>> Set up a email distribution group, add all 'operators' to the email
>> distribution group, and register that 'group' as the operator.
>>
>> --
>> Arnie Rowland, Ph.D.
>> Westwood Consulting, Inc
>>
>> Most good judgment comes from experience.
>> Most experience comes from bad judgment.
>> - Anonymous
>>
>>
>> <paladinomich***@gmail.com> wrote in message
>> news:1158867764.150580.16490@i3g2000cwc.googlegroups.com...
>> > In the Notifications section of SQL Server Agent > Jobs, only one Net
>> > send operator can be selected. Setting up an operator with multiple
>> > semicolon delimited computer names as recommended in the following
>> > thread did not work:
>> > http://groups.google.com/group/microsoft.public.sqlserver.server/browse_thread/thread/ffe4448cff880915/ff21fe3879bd473d?lnk=st&q=sql+server+net+send+multiple+operators&rnum=1#ff21fe3879bd473d
>> >
>> > Any other ideas? Thanks in advance.
>> >