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 |
|
Vack
Aged Yak Warrior
530 Posts |
 Posted - 2009-05-19 : 09:50:06
|
| I have a user that would like to know when a posting procedure has started. There is a table that will have records inserted into it when the procedure starts. So that would be my event to know when the posting is started. I was reading a little about notification services and that seems like it may be what I'm looking for. But it seems like you need to be a VB programmer to use it. Are there any templates or any other programs out there that will do what I'm looking for? |
|
|
jholovacs
Posting Yak Master
163 Posts |
Posted - 2009-05-19 : 11:39:35
|
What about Database Mail? You can include an email notification at the beginning of your proc.
SELECT TOP 1 w.[name]FROM dbo.women wINNER JOIN dbo.inlaws i ON i.inlaw_id = w.parent_idWHERE i.net_worth > 10000000 AND i.status IN ('dead', 'dying') AND w.husband_id IS NULLORDER BY w.hotness_factor DESC |
 |
|
|
|
|
|
Notification Services