Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
shaneschmidt
Starting Member
17 Posts |
 Posted - 2003-09-22 : 03:04:20
|
| Is there any anyway of notifying more than one uservia net send. All attempts to add more than one userhas failed. Is there a way around it.RegardsShane |
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-22 : 03:19:26
|
| What about running a stored proc or batch file that does individual NET SENDs to each user ?Damian |
 |
|
|
shaneschmidt
Starting Member
17 Posts |
Posted - 2003-09-22 : 18:36:16
|
| How... My DBA knowledge is limited when it comes to job ids and notifications etc ? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-22 : 18:40:25
|
| What is the requirement here (how is this even SQL Server related)? Why don't you just create a group on the domain, then send the message to the group? We did that for thresholds at one customer site.Tara |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2003-09-22 : 19:30:22
|
quote:
how is this even SQL Server related)?
Because you might want to send an alert when a job fails. Settle Tara  Creating a group was actually my first thought, but I didn't think you could send to just a group. That would be ideal.Otherwise, you can use xp_cmdshell to send them from TSQL like this :Exec xp_cmdshell 'net send username "Hi There"'You can do that many times in a TSQL script (even in a loop if you want to REALLY annoy co-workers in fun office games ).Damian |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-22 : 19:46:21
|
quote:
Originally posted by Merkin
Because you might want to send an alert when a job fails. Settle Tara
True, but why not just use the job notifications then? You could setup an operator that contains multiple users and then send the message to the operator.quote:
Originally posted by Merkin
Creating a group was actually my first thought, but I didn't think you could send to just a group. That would be ideal.
We did it at a customer site, but I can't remember how and I do not have access to their network anymore to check what we did.Tara |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-11-15 : 05:25:18
|
| ROFLYou bumped a 2 year old thread for THAT ?Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-15 : 12:37:27
|
| What did I miss? Someone bump then delete?Tara Kizeraka tduggan |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2005-11-15 : 15:23:09
|
Dammit, I hate that.Yes someone bumped it and said "Use notification services" Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
Notification ( Net Send)