Daily or Random scans of a DB for updates

[cvillard]

I am building an application with ASP.net that is used for keeping up
to date on pending tasks. I would like to send emails when items have
been stagnant, or are going to expire.

Does anyone know of or have feedback/ideas on creating something
(software, service) to scan the database for items and then shoot off
an email.

Thanks
Chuck

[Steve C. Orr [MVP, MCSD]]

A Windows Service would be the best way to implement this functionality
assuming you aren't using a shared web host that restricts such things.

Here's more info on Windows Services:
http://msdn.microsoft.com/library/de...plications.asp

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

<cv******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

I am building an application with ASP.net that is used for keeping up
to date on pending tasks. I would like to send emails when items have
been stagnant, or are going to expire.

Does anyone know of or have feedback/ideas on creating something
(software, service) to scan the database for items and then shoot off
an email.

Thanks
Chuck

[Eliyahu Goldin]

Chuck,

Consider using the database job scheduler.

Eliyahu

<cv******@gmail.com> wrote in message
news:11*********************@g14g2000cwa.googlegro ups.com...

I am building an application with ASP.net that is used for keeping up
to date on pending tasks. I would like to send emails when items have
been stagnant, or are going to expire.

Does anyone know of or have feedback/ideas on creating something
(software, service) to scan the database for items and then shoot off
an email.

Thanks
Chuck