Solved

NET SEND Address

Posted on 2004-03-24
4
1,501 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
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…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.

717 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