I done the email configuration and done the email sending code in oracle apex page, but unable to send emails properly, some time it works smoothly but all of a sudden it stuck and my emails appear in mail queue, can anyone guide me no this that what things are missing in the process?
Asked
Active
Viewed 637 times
0
-
Emails will stay in `apex_mail_queue` if there is an error sending the email. For the emails that are "stuck", is there a value in the `MAIL_SEND_ERROR` column of that view? – EJ Egyed Jul 23 '21 at 12:40
-
this column is blank – alibutt Jul 25 '21 at 14:40
-
Do the emails send if you call `APEX_MAIL.PUSH_QUEUE`? – EJ Egyed Jul 26 '21 at 12:57
-
emails are sent by a scheduler job. Check ALL_SCHEDULER_JOBS to make sure it is enabled and running successfully at regular intervals. – Connor McDonald Jul 27 '21 at 04:22
-
It's done, Thanks for the guidance and help – alibutt Jul 30 '21 at 19:16