sending emails from oracle upon monitoring the database

[jith87]

hi,
i have a database that contains data about all the servers conneced in a network... the database gets loaded with data about the severs every 3 mins.i need to monitor the servers' performance.if the memory usage of the server increases rapidly i need to send an email to the admin user of that server.is it possible by using triggers. i have a vbscript that when executed simply sends email. is there any mechanism to connect oracle and the vbscript file to send email? if not provide me a solution.
thanks in advance,
jith

[amitpatel66]

hi,
i have a database that contains data about all the servers conneced in a network... the database gets loaded with data about the severs every 3 mins.i need to monitor the servers' performance.if the memory usage of the server increases rapidly i need to send an email to the admin user of that server.is it possible by using triggers. i have a vbscript that when executed simply sends email. is there any mechanism to connect oracle and the vbscript file to send email? if not provide me a solution.
thanks in advance,
jith

Check out the below trigger used to send mail:

CREATE or replace TRIGGER status_check 
AFTER  update ON DM_JOB_S
FOR EACH ROW
declare
mail_conn utl_smtp.connection;
var number:=5;
BEGIN
IF :old.method_name='dm_honey_job' AND :old.is_inactive =0 AND :new.is_inactive =1 THEN
mail_conn :=utl_smtp.open_connection('localhost',100);
utl_smtp.helo(mail_conn,'localhost');
utl_smtp.mail(mail_conn,'tmpdoc1@localhost');
utl_smtp.rcpt(mail_conn,'[e-mail]');
utl_smtp.data(mail_conn,'Database error!!!');
utl_smtp.quit(mail_conn);
ENd IF;
DBMS_OUTPUT.PUT_LINE(var);
END;
 

[jith87]

you see i am just a beginner. so could you please give me some explanation or the utility that can be used.

[amitpatel66]

you see i am just a beginner. so could you please give me some explanation or the utility that can be used.

Check for explanation of UTL_SMTP here and here