Solved

NET SEND Address

Posted on 2004-03-24
4
1,051 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
0
Comment
Question by:NorBro
  • 2
4 Comments
 
LVL 4

Expert Comment

by:squatex
ID: 10668238
You will need to create a seperate operator and add each of them seperately to the alert for your event.
0
 

Author Comment

by:NorBro
ID: 10668673
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
0
 
LVL 13

Accepted Solution

by:
danblake earned 150 total points
ID: 10669253
This is untested...
Can you create a group within your NT Admin/W2K Admin which has the individual operators required, then generate a net send DOMAINNAME/groupname


By just adding the DOMAINNAME/GROUPNAME

such as SUPPORTGROUP is the groupname or
            INFRASUPPORT or
            DBSUPPORT...
0
 

Author Comment

by:NorBro
ID: 10765086
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
0

Featured Post

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

Let's review the features of new SQL Server 2012 (Denali CTP3). It listed as below: PERCENT_RANK(): PERCENT_RANK() function will returns the percentage value of rank of the values among its group. PERCENT_RANK() function value always in be…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now