I am using oracle 10 client and connecting to an oracle 10 database. I am still relatively new to oracle and I am looking into a way to schedule and send an email to one or multiple recipients(very simple email that shows a link to a web page). Is there any way to do this in oracle. All I need is really sender, recipient, subject and body and in that body I need to attach a hyperlink. Is this possible. I also need to schedule this email to run every Monday. Thanks.
Thanks everyone for responding.
O.k I have figured out how to send an email and have created a stored procedure that fetches data from a table and sends out an email to recipients in that table. Looks like it is working.
Now the DBMS_scheduler is the part I do not understand. Am I creating a stored procedure or something to schedule this once a week. All I need is to make a call to the stored procedure I just created for sending mail that will fire every Monday morning. Sorry, I just didn't quite understand what I was reading. Plus I did not understand how to put it together. Could someone provide some sample code for scheduling on a weekly basis.
hahaha it's that easy eh. I think I need to go home
What I was getting at though is how do I wrap this begin and end together or do I simply copy and paste make the necessary changes to variables and execute.
Do I not have to say create procedure or whatever. Not sure what it is that I'm creating.
DBMS_SCHEDULER.CREATE_JOB creates a job; that's it. It needs BEGIN-END as it is a PL/SQL product - a package procedure so - either put it into BEGIN-END, or run with EXECUTE package_name.procedure_name.