Im running an sql script on Linux at regular intervals through CRONTAB.
How can I have the DBA alerted (via email or any other means) incase a unique constraint or any other exception occurs?
Thanks.
Printable View
Im running an sql script on Linux at regular intervals through CRONTAB.
How can I have the DBA alerted (via email or any other means) incase a unique constraint or any other exception occurs?
Thanks.
If database is 8.1.6 you can use UTL_SMTP to send DBA mail from exception handler.
Could you explain with an example on how to do it please?
Thanks.