469,133 Members | 1,209 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,133 developers. It's quick & easy.

help with setting up a reminder

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,
Dec 10 '07 #1
1 1484
<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
Dec 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

8 posts views Thread by . . | last post: by
4 posts views Thread by sonhadorPR | last post: by
1 post views Thread by Jeremy Simpson | last post: by
reply views Thread by zhoujie | last post: by
1 post views Thread by Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.