We help IT Professionals succeed at work.

NET SEND Address

NorBro
NorBro asked
on
Medium Priority
2,460 Views
Last Modified: 2010-07-27
In SQLserver agent. operators there is a field net send address. I want to be able to use this to a send a message to more than one operator.

 Can this be done ? what is the correct syntax ?

The problem is when you try to use the 'notification' tab of jobs running under SQLagent you can only define one netsend operator.
 
Thanks
Comment
Watch Question

Commented:
You will need to create a seperate operator and add each of them seperately to the alert for your event.

Author

Commented:
The problem is when you try to use the 'notification' tab of jobs running under SQLagent you can only define one netsend operator !!!

thats what im trying to get around
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
No that didnt work.

Have found a work around by setting up the net send commands i want in a cmd file and adding the running of this as a step on the sql agent jobs that it will run if the previous step fails.
Not ideal but it works !!!

thanks for you help anyway so i will award the points
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.