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.