<be************@gmail.comwrote in message
news:3a**********************************@18g2000h sf.googlegroups.com...
Hi there,
I need help with setting up a reminder in my sql.
It needs to check the inventory on hand for a product and if it is
below 3 unit, it needs to send an e-mail reminder to the user.
how do I set this up?
Thanks,
A simple way is to setup a scheduled task to run say every 5 minutes that
checks the number and emails the user.
If you want more than that, look into Notification Services.
--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com
http://www.greenms.com/sqlserver.html