Use trigger to fore off email if no data entered
I have a MySQL-driven app in development that users have to enter data by a deadline which is different for each job. The deadline time is stored in the database along with the user's email address. What I'd like to do is to have a way of polling the database every 5 minutes or so and if no data has been entered by - say - 30 minutes before the deadline, an email is sent to the relevent user as a reminder. It's running on Windows 2000 Server and so I could probably use vbs but I'm not that good at it, or can I use a trigger? I'll use Blat for email as it's small and fast.
Subject
Views
Written By
Posted
Use trigger to fore off email if no data entered
2545
June 22, 2006 04:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.