How to send email on perticular date and time?
-
Hi, I need to implement a function that sends emails on a perticular date and time. The date and time is specified by the user when he posts a new event into a on-line calendar. The user should be allowed to decide when an event notification email will be sent to a group of people. The database used for the project is SQL server. I learn about SQL server job scheduler can do it. But I don't know how to add a job into SQL server job list when a record is submited into database from web form. Is there anybody having any advices? Thanks in advance!
-
Hi, I need to implement a function that sends emails on a perticular date and time. The date and time is specified by the user when he posts a new event into a on-line calendar. The user should be allowed to decide when an event notification email will be sent to a group of people. The database used for the project is SQL server. I learn about SQL server job scheduler can do it. But I don't know how to add a job into SQL server job list when a record is submited into database from web form. Is there anybody having any advices? Thanks in advance!
firstly add the time and date from web form to database table for each user. then add only one job that run after each minute in Management-->SQL Jobs. Now what this job will be done ?. It will first check the date and time of users and then it will send mail using following code if the user is reach to its exact time. Code you can view from following link: http://www.vbforums.com/archive/index.php/t-280616.html and read about how to add a new SQL server job in database in detail. Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623
-
firstly add the time and date from web form to database table for each user. then add only one job that run after each minute in Management-->SQL Jobs. Now what this job will be done ?. It will first check the date and time of users and then it will send mail using following code if the user is reach to its exact time. Code you can view from following link: http://www.vbforums.com/archive/index.php/t-280616.html and read about how to add a new SQL server job in database in detail. Qaisar Mehmood Mughal ............................................................................... May Allah gave u success in all fields of life. (Aameen) ............................................................................... Software Engineer ISF - Islamabad Software Factory 3rd Floor, Software Technology Park Constitution Avenue, Islamabad 44000, Pakistan www.isf.com.pk qaisar@isf.com.pk , qmmughal@gmail.com Phone: +92 (51) 2825387 : 0321-5226623