Scheduling a Mail Sending Job with APEX
657200Feb 20 2009 — edited Sep 14 2010Hi
I would like to know if it is possible to schedule an e-mail sending job with APEX(for purposes like birthday reminders etc). Currently, I am able to send e-mail from APEX by creating a process which is triggered by a button. I am using the apex_mail.send procedure to send e-mail. This is working fine, but I would ideally want the email sending process to be scheduled to run independent of a manual trigger, i.e. the system date should be the trigger, and it should repeat after a specified interval. (The method should be such that emails are sent out even when the APEX application is not running,i.e. the process should take the data directly from the database.)
Thanks,
Kamal