This content has been marked as final. Show 5 replies
CREATE OR REPLACE FUNCTION send_email (
input_recipient IN VARCHAR2,
input_sender IN VARCHAR2,
input_subject IN VARCHAR2 DEFAULT NULL,
input_message IN VARCHAR2) RETURN VARCHAR2 IS
l_mailhost VARCHAR2(255) := '<MAIL HOST IP ADDRESS>';
crlf VARCHAR2( 2 ):= CHR( 13 ) || CHR( 10 );
l_mail_conn := UTL_SMTP.OPEN_CONNECTION(l_mailhost, <port>); --<port> Port
l_msg_text := 'MAIL TEXT';
WHEN OTHERS THENs
-- Call the procedure
send_email(p_sender => 'ORACLE SCHEDULAR',
p_recipient => 'email@example.com',
p_subject => 'SCHEDULAR JOB',
p_message => 'SCHEDULAR JOB Completed Succesfully' );
This is just for reference. On the Scheduler webpage
under Oracle Scheduler Utilities there is a utility job notification package that allows sending e-mail on job failure/success/completion.
What would I enter for mail host? Where would I find out this info?
I know this is quite an old blog, but I am looking for the above mentioned package to use this on a 10g database. However, the link from Ravis reply above -
- does not work any more. I have searched other areas as well and found the same link several times, but no reference to the changed location. Hope you can help me out here.
Good question. Turns out this page was moved and google doesn't know about the new location (and it doesn't seem to be connected to Oracle's home page).
Anyway, it is now located here