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 - 2002-06-11 : 10:17:53
|
| neil writes "Dear SQL Team,I am writing a web based search engine, and need some help.I would like to create a job schedule in SQL 7 to auto email notify the registered users of the site when data uploaded to the site matches there saved search criteria, I think that I would schedule this job to run once a week.Is this the best way to handle auto email notify ?And if so can you help with the best way to go about this.Many Thanks Neil" |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-11 : 11:14:28
|
| If you are not using DTS that's got it's own little sendmail task you can :xp_sendmail {[@recipients =] 'recipients [;...n]'} [,[@message =] 'message'] [,[@query =] 'query'] [,[@attachments =] 'attachments [;...n]'] [,[@copy_recipients =] 'copy_recipients [;...n]' [,[@blind_copy_recipients =] 'blind_copy_recipients [;...n]' [,[@subject =] 'subject'] [,[@type =] 'type'] [,[@attach_results =] 'attach_value'] [,[@no_output =] 'output_value'] [,[@no_header =] 'header_value'] [,[@width =] width] [,[@separator =] 'separator'] [,[@echo_error =] 'echo_value'] [,[@set_user =] 'user'] [,[@dbuse =] 'database']You need to have a mail profile connected to your sql server though. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
|
|
|
|
|
|
|
Email auto notify