Scheduled tasks

Hi there,

My web app needs to run a schduled task - every hour it
needs to scan the DB, find any updates and - if there are
updates - send an email to an address list, notifyling
them of the change.

I know how to scan the DB for chnages, how to send and
SMTP mail to an address list, and how to set this mail up
such that it gives a simple link to the appropriate place
in the web app - the only thing I lack experience in is
setting up scheduled apps. This would have to be done on
the server (Windows 2000).

I am posting thios question to both the distributed apps
and the servers newsgroups, as it may be appropriate for
either.

Thanks,

Paul N

Ken
Tue Feb 10 20:59:31 CST 2004

Use the Windows Task Scheduler.

Start -> Settings -> Control Panel -> Scheduled Tasks

Cheers
Ken

"Paul N" <pnelson@amylin.com> wrote in message
news:e61a01c3f030$23fbd930$a601280a@phx.gbl...
: Hi there,
:
: My web app needs to run a schduled task - every hour it
: needs to scan the DB, find any updates and - if there are
: updates - send an email to an address list, notifyling
: them of the change.
:
: I know how to scan the DB for chnages, how to send and
: SMTP mail to an address list, and how to set this mail up
: such that it gives a simple link to the appropriate place
: in the web app - the only thing I lack experience in is
: setting up scheduled apps. This would have to be done on
: the server (Windows 2000).
:
: I am posting thios question to both the distributed apps
: and the servers newsgroups, as it may be appropriate for
: either.
:
: Thanks,
:
: Paul N