running asp page in background.

[ketankshah]

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.

 

[tschonken]

Try writing a vbs file that gets kicked of by a batch file that is executed when the message is posted . Have used it in the past and it works just fine.

 

[ketankshah]

Thanks tschonken for a quick reply. But can you help in how to write a vbs file and how to trigger it by a batch file through an asp page?

Thanks again.

Ketan