I am trying to use store procedue to read data from Oracle 10g table and send email message out. The store procedue needs to run every 5min and it go thru the table and check the field->SendMail. if it is false/null then send the email outfor that record and update it to true,otherwise go to the next one. I can use SMTP from W2K3 server to send the messge.
I am not sure what needs to be done to make this work, so pls provide some sample if possible.