1 Replies - 5212 Views - Last Post: 03 March 2011 - 03:46 PM Rate Topic: -----

#1 rahul14881  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 1
  • Joined: 03-March 11

email notification

Posted 03 March 2011 - 09:05 AM


I wrote an asp.net program that is designed to retrieve user data. The process, in which the user can log in to the system and input his data, has a Start Date and an End Date where the user is not allowed to log in before the start date or after the end date.

I want to send an email notification to the users to log in to the system and input their data. This email notification has to be sent on the Start Date of the process (which is stored in an a database table). Additionally, two reminder emails must be sent to the users of the system. The time of sending the email reminder will be calculated automatically by generating two dates between the Start Date and End Date of the process.

The problem I am facing at the moment is how to send the email notification automatically. I wrote the procedure for sending the email notification and I stored it in an asp.net web service. But how can I trigger this procedure on Start Date and on each Reminder Date?

I tried several methods and thought of using timers but to no avail.

Appreciate your help

Is This A Good Question/Topic? 0
  • +

Replies To: email notification

#2 Nakor  Icon User is offline

  • Professional Lurker
  • member icon

Reputation: 448
  • View blog
  • Posts: 1,504
  • Joined: 28-April 09

Re: email notification

Posted 03 March 2011 - 03:46 PM

create a job in your database and send the email directly from the database

Sending email sql server

MSDN Send_DBMail

you can google it for a few hundred other sources
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1