How do I schedule a recurring job to send an email
595185Sep 24 2007 — edited Sep 26 2007My issue is that I wrote a PL/SQL procedure and was going to use the Oracle's dbms_jobs to call it ever day at 4:30 pm to send out notification emails and the changes scheduled for the next day as part of our APEX project.
I understand email now and use it elsewhere in the project fine(for on demand emailing). However, when I tested my Stored Proc Oracle gacked on itself saying I can only use the APEX email function when its run from an APEX application.
So, I need for APEX to be able to schedule jobs and hold my Stored Proc instead of the db itself, I guess. Is there a way around this? Does APEX have its own scheduler that it could call the sp I wrote that uses the email function of APEX?
As always, thanks for your time and reply's in advance!
Gib