Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Dec 25, 2012 07:55 AM by Haixia Xie - MSFT
Dec 21, 2012 06:34 AM|LINK
i have table customerinfo
i want to send mail when birthdate comes.
How is it possible with webservices...
Thanks in advance
Dec 21, 2012 06:39 AM|LINK
You can use SQL Server Jobs to check the data in your table and send mails.
Dec 21, 2012 07:31 AM|LINK
Dec 21, 2012 07:43 AM|LINK
What is the error you are getting?
Dec 21, 2012 07:49 AM|LINK
message not sending it remains in queued
and i want to send on date arrives
Dec 21, 2012 04:37 PM|LINK
You can do something like this -
Create a console app with your logic that will check the date of birth and send an email if it is the day.
Schedule this console app to run every 24 hours and then it will run once in a day, you can change this how many times it will run and do the necessary job.
You can create windows service and achieve the same thing.
Dec 22, 2012 05:41 AM|LINK
thanks for reply
How to create such web serivce.. Please explain
Dec 25, 2012 07:55 AM|LINK
As kushalrdalal suggested above, you can use windows service to achieve the goal. Create a web service for email sending, and another project to trigger and call the service and use Windows Service to control the timer.
#Email Sending Web Service
Below blog provide a sample to create a simple windows service.