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. |
 |
|
|
|
|
|
auto email