use net send to send meesage when alert fired? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

use net send to send meesage when alert fired?

Hi All
if anyone knows how to use net send to send a message to DBA if an alert fired? for example: hardware fails with severity level 24. we want to know it but we don’t use sqlagentmail function on sql server 2000. or is there any way to notify DBA? any idea will be very appreciated. thanks, Long
Referhttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15583 and it seems both the questions are from same person. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided �AS IS� with no rights for the sake of knowledge sharing.
Hi,
refer answer
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=15586 and refer * sp_add_alert * in BOL for more. * donot post duplicate questions. Regards Hemantgiri S. Goswami
[email protected]
"Humans don’t have Caliber to PASS TIME , Time it self Pass or Fail Humans" – by Hemantgiri S. Goswami
]]>