Post reply

Sending mails from Sql Server 2005 Database mail feature in automated way.

  • March 12, 2007 at 6:13 am

    #171621

    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.

  • March 15, 2007 at 8:49 am

    #695242

    in BOL there is a script to run to enable database mail for a user

    as part of the process that updates that table you can have it run that script with the email address

  • March 15, 2007 at 11:34 am

    #695308

    please do not double post your issues.

    Everything you can imagine is real.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply