Sending Email automatically

• John McConalogue

  SSC Enthusiast

  Points: 100

  More actions

  August 15, 2005 at 5:16 am

  #67836

  Does anyone know how to send email automatically.

  I have records in a table that contains a date added. I want that when todays date is 10 days past the date added in the table that an email will be sent off to the person who added the record. The persons email address is also stored in the table along with the record they added.

  I know the code to use to send an email but what I don't know is how do you schedule the code to kick off to check the dates and to then send off the email.

  anyone any ideas?

  macca

• AJ Ahrens

  SSC-Insane

  Points: 20676

  More actions

  August 15, 2005 at 6:06 am

  #582101

  Probably the easiest way is to create a job and have it scheduled daily to either A.  run a stored procedure with the code or B.  run a DTS package with the code...

  
  
  Good Hunting!

  AJ Ahrens
  
  
  webmaster@kritter.net