ketankshah
IS-IT--Management
I have a requirements. In bulleting board, if someone posts a message, the code should retrieve all the members and send them emails automatically. This should happen in background so the user who is posting the message should not have to wait until all the emails are sent. I have tried using stored procedure and triggers but all are sychronomous and waits till the execution is complete.
Has any body knows how to do it? SQL server scheduler won't work as the mails are to be sent only when a message has been posted and not at a specific time interval.
Any kind of help will be useful.
Thanks.
Has any body knows how to do it? SQL server scheduler won't work as the mails are to be sent only when a message has been posted and not at a specific time interval.
Any kind of help will be useful.
Thanks.