Thank you for the replies.But let i tel u one thing. Now the curreent process is Based on a character value 'Q'.Along with the data stored in database this char value is also inserted.Wen it is inserted in the database,it turns to 'S'-for send.The problem is i cant do anything with database.And i can only work in the application.So do this suggestion be effective in this situation?
On Wed, Nov 26, 2008 at 7:20 AM, AstroDrabb <[EMAIL PROTECTED]> wrote: > On Tue, Nov 25, 2008 at 1:20 PM, rhaazy <[EMAIL PROTECTED]> wrote: > >> >> I think you would have to do something like store the emails in a >> database with the "date to be sent" column as what you would compare >> using a timer in your application that would fire, say, every hour. >> Thinking about it though I think storing emails in a database sounds >> like a bad idea... Hopefully the proessionals here have a better >> suggestion, I'd be very interested in learning how to do this myself. >> >> > Well, you could write a "sender" app and then have the main app create > Windows Task Scheduler events. Task scheduler is built-in and ready to go > and well tested/used. No need to reinvent the wheel. The main app handles > just creating task scheduler items and the sender app just sends based on > the parameters passed. Or you could use a DB to hold the info to be sent > and just pass the sender app a PK of the item to handle. > > Many ways to do this simple task. I prefer the don't-reinvent-the-wheel > approach myself. The task scheduler also will allow admins to see details > of what task failed, etc. > > > Regards Jeena
