Hello,
I would like to send email notifications in some defined intervals but ideally without the need of an external SMTP server (if I could reliably use an external SMTP server, it would be easy to do so either with UTL_SMTP or with UTL_TCP). It's possible to send mails from within apps using the APEX_MAIL package but I cannot use this package in a job scheduler as it needs a valid session. It probably should be possible to create a "fake" session (Martin Giffy D'Souza on Oracle APEX: How to Create an APEX Session in PL/SQL) in a scheduled job and then send mails using APEX_MAIL but I hope there could be some more straightforward solution, so any hints and guidlines would be highly appreciated.
Regards,
Pavel