How to notify?

  • Thread starter Thread starter Viktor Popov
  • Start date Start date
V

Viktor Popov

Hi,
I have a table in MS SQL -
NotifyTBL
==============
ID int Primary Key
SearchID int
OfferID int

this table is populated when a user Insert values in OffersTBL. A trigger
does this automatically. What I want to do is every 30 min to check if there
is a new records in NotifyTBL and if there are I would like to send e-mail
message to users. How could be accomplished that?

Thank you !

Viktor
 
Thanks for the reply!
I would like to ask how to send the e-mails- by MS SQL SERVER in some other
way?
 
You could let SQL Server do the work for you by
creating a Datetime field in NotifyTBL and setting
it's default value to getdate() (the current date and time).
Then build a scheduled Job to run a sql script every half
hour and use sql server to send the mail notification.

Awk
 
Back
Top