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 - 2004-11-05 : 08:34:49
|
| Trevor writes "I am quite new to the world of Sql Server, so I hope you will be patient. I would like to know the steps to create a background task to look at the contents of a table, and as the table is appended, send an email(alert?), if the contents of a field change from say "medium" to "high".Does SQL server 2000 allow background tasks (ie that run like services)?Your help is appreciated." |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2004-11-05 : 11:17:15
|
| investigate "triggers" to create entries in central table to notify that a record has changed.investigate "sql agent" to automate running of tasks.investiage "mail queue" (in the articles section) for an overall look at a solution that does this sort of thing. |
 |
|
|
|
|
|
Email background query results