Monday, March 26, 2012

Net send message

SQL Server 2000 SP3.
Is it possible to send a "net send" message to more than 1 operator in SQL
Server job Notifications ?. If not, is there a work-around ?.
We need to send a "Net Send" message when a job fails to more than 1
operator. How this can be possible ? I have defined multiple operators in
"SQL Server Agent--> Operators" but it is one or the other in the job's
Notifications.
T.I.ANet Send is not an effective way to communicate/alert people. IMHO, it
shouldn't even have been included in the product. You'd be better off to sen
d
an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
job failure to log an error in the app eventlog, and let your monitoring
system pick it up and alert you.
Linchi
"DXC" wrote:

> SQL Server 2000 SP3.
> Is it possible to send a "net send" message to more than 1 operator in SQL
> Server job Notifications ?. If not, is there a work-around ?.
> We need to send a "Net Send" message when a job fails to more than 1
> operator. How this can be possible ? I have defined multiple operators in
> "SQL Server Agent--> Operators" but it is one or the other in the job's
> Notifications.
> T.I.A|||Thanks.................The problem is, server is in one domain (A secur
e
domain) and the monitoring will be done on another domain where 2 domains
don't see each other........
"Linchi Shea" wrote:
[vbcol=seagreen]
> Net Send is not an effective way to communicate/alert people. IMHO, it
> shouldn't even have been included in the product. You'd be better off to s
end
> an email. Or if you are monitoring your evenlogs, execute RAISERROR upon a
> job failure to log an error in the app eventlog, and let your monitoring
> system pick it up and alert you.
> Linchi
> "DXC" wrote:
>sql

No comments:

Post a Comment