SEO

#1 (**permalink**) 03-01-2008, 02:45 PM

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,

#2 (**permalink**) 03-01-2008, 02:45 PM

<behnaz.behzadi@gmail.com> wrote in message
news:3a300438-ed45-4398-b940-5cb0500f46d8@18g2000hsf.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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode