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.

[Sijin Joseph]

One way would be to keep track of the Max(ID) in the table, if the value
changes after 30 mins you know that new values have been inserted, you
can retrieve the new rows by using
select * from NotifyTBL where ID > lastMaxID

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Viktor Popov wrote:

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.

[Viktor Popov]

Thanks for the reply!
I would like to ask how to send the e-mails- by MS SQL SERVER in some other
way?

"Sijin Joseph" <si***************@hotmail.com> wrote in message
news:#n**************@tk2msftngp13.phx.gbl...

One way would be to keep track of the Max(ID) in the table, if the value
changes after 30 mins you know that new values have been inserted, you
can retrieve the new rows by using
select * from NotifyTBL where ID > lastMaxID

Sijin Joseph
http://www.indiangeek.net
http://weblogs.asp.net/sjoseph

Viktor Popov wrote:

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.

---
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 ã.

[awk]

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

"Viktor Popov" <vi****@yahoo.com> wrote in message
news:ey**************@TK2MSFTNGP10.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.