How to notify?

[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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 27.8.2004 a.

[Hermit Dave]

it will have to be a windows app or a service cause you cannot have a timer
on asp.net which automatically executes the code based on timer interval.

so start with a win app.. do a query on count and keep in memory..
set the timer to relevent interval (i dont know if you can set it to half an
hour but you could have a variable which says how many times the time has
invoked and then do a count again. use SqlCommand.ExecuteScalar() to fetch
the value of count and compare.. if count is greater than you have new
records. if so Create an instance of MailMessage and populate it with your
required data and then use SmtpMail.Send specifying the right smtp server
address.

hth

--

Regards,

Hermit Dave
(http://hdave.blogspot.com)
"Viktor Popov" <vi****@yahoo.com> wrote in message
news:ef**************@TK2MSFTNGP09.phx.gbl...

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
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.745 / Virus Database: 497 - Release Date: 27.8.2004 a.

[Lucas Tam]

"Viktor Popov" <vi****@yahoo.com> wrote in
news:ef**************@TK2MSFTNGP09.phx.gbl:

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?

-Windows Service
-SQL Server Scheduled Event
-Schedule an ASP.NET page to be loaded every 30 minutes to execute the code

#1 is probably your best choice.
--
Lucas Tam (RE********@rogers.com)
Please delete "REMOVE" from the e-mail address when replying.
http://members.ebay.com/aboutme/coolspot18/