send mail through database using asp.net

Hi friends,

I am using Asp.net application and sql server 2005. I assigned job for users using job scheduling. ie activate and deactivate while we assign the job at particular time it change at that time(activate/deactivate). While the changes will come at that time i need to send mail for that particular user.
Normally we can send mail using asp.net i know.But in this scenario how can we send mail automatically in db.

IF you have any idea, reply me.

Hope yours reply.

I am using SendMailJPkg package for sending mails through Oracle Database (9i).
You can check that.

Hi ,

Thanks for your's reply. Do u know any other software before configure dbmail.

You could write a windows service or a scheduled task that runs every x minutes, checking for emails to send.

hi mendhak,

Thanks for yours reply.But i am using web application.what software need to install while configure dbmail?? This is my question.

Hope your's reply.