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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2006-12-22 : 07:48:38
|
Qazi writes "I have table with |ticketno|backupemail|status| i want to send an email to backupemail if the ticket status is active automaticallyHow can i write a stored procedure for it?example:"select ticketno from ticket where status='active'"and then from here i want to send an email to backup email person to notify that this particular ticket staus is still active." |
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2006-12-22 : 12:15:08
|
You'll need to configure SQL Mail (2000) or Database Mail (2005) and then use the mail stored procedures xp_sendmail (SQL Mail) or sp_send_dbmail (Database Mail) to send email. See Books Online for details and examples. |
|
|
|
|
|