How to send automate email using Database mail feature of Sql server 2005

• Madhusudan-348058

  SSC Veteran

  Points: 255

  More actions

  March 14, 2007 at 12:53 am

  #116601

   

  Hi EveryOne,

  I have successfully created and configured  profile manually for Database Mail and also was able to send mail using Test Mail option of Database Mail.

  Now i want to do it above thing automated.

  Suppose there is table UserList in which there is column name Email containing email address of users.

  1) I want that all the email address should be automatically configured (parrallel to Database Mail-->Configure DataBase Mail option) when a record is added to the UserList Table.

  2) I also want to send a mail to all the configured users once in a day in a day or periodically but automatically.

   

  Thanks

  Madhusudan.

• bledu

  SSChampion

  Points: 12335

  More actions

  March 14, 2007 at 10:38 am

  #695019

  create a job with your chosen schedule and then call a stored proc which uses sp_send_dbmail to send your mail

  ---

  Everything you can imagine is real.