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 - 2005-03-07 : 07:43:41
|
| shannon writes "Here's what I do:I'm using a drag and drop query tool to extract data from anSQL database, I then create reports from the queried data withanother drag and drop type application. I'm not an SQL programmer but consider myself to be an end user and I do own the data and I do the data entry.Question: I'd like create logic whereby I'd set a condition like: A certain field in a table or group of fields contain something I'd like to be made aware of. I'd like to be emailed when my condition gets met.For example: Lets say I've got table called WEATHER that holds: Lightning, Rain, High Winds, Frost. In my front end data entry application the gui displays a drop down for choosing one of the weather types and it then gets written to the database.When WEATHER = lightning send me an email telling me that Lighting has just happened. etc...What I want to know is: Do you know of any end user/easy to usetool that would link to the database and would be constantly "listening" to the database allowing me to create any rule I wanted for an email notify?I've been trying to find trends in my database so that I can actappropriately on them. The problem I'm now finding is that unless I'm asking the right question, I'm missing trends that are really not that obvious. If I could create rules like:When ever anything gets repeated more than once please tell me.I'm asking this question because we recently discovered a trend where: Wind blowing from the N.E. at 20kms per hour and the temperature was -10celcius on a friday my problem occured.This is like the Tree in the forest scenario. I'll admit that I would never have asked this question.but if a basic rule like: Field x, field y, field z, and field arepeated more than once I'm thinking I could have been notified.I'm sure I'd get a lot of crap emails but at least I'd be able to decide if it was valuable or not.Again, I'm looking for something to build these rules with thatcould be like drag and drop,(for dummies) and wouldn't involve IT everytime I wanted to make a new rule.Thanks!!Shannon Bouchard." |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-03-07 : 11:17:34
|
| I don't think there is any completely ineteractive, out of the box way to do this. You can interactively create an alert with an email response using Enterprise Manager, but you would have to raise an error to kick it off. There are several possibilities for that direction but they're all Klugy, I wouldn't recommend them. Looks like you're going to have to start bribing your IT guys. Dounuts usually works well for that.Be One with the OptimizerTG |
 |
|
|
|
|
|
|
|
auto nofity