Send a Reminder

  • Thread starter Thread starter Mariame
  • Start date Start date
M

Mariame

Hi Everyone
I send an email upon the user request to the administrator & i send a
reminder in case of two day pass without any action from the administrator
The problem is that i cant find the event that fire the Reminder action???
Thx in Adv
 
There wouldn't and can't be an event. Your code only runs when there is a
page to process. What I would do is write a sql job that checks nightly for
stuff like this and sends out the email. In a unix environment I would write
a cron job. Look to see if there is something like that in Windows.
 
Thx Scott for ur response
but is it possible that the sql job call a visual basic code to be
executed???
 
Mariame said:
Thx Scott for ur response
but is it possible that the sql job call a visual basic code to be
executed???
Click to expand...

Write a WSH script that queries the DB for a recordset of notifications
to be made and processes it. Use Scheduled Tasks to schedule it.
 
Back
Top