Home » SQL & PL/SQL » SQL & PL/SQL » Email Notification (Windows 03)
Email Notification [message #438595] Mon, 11 January 2010 02:41 Go to next message
israel_alvis@yahoo.com
Messages: 1
Registered: January 2010
Location: makati
Junior Member
Hi All,

Email Notification using ORA 10g. DBA Scripts e.g sending every 10 minutes.
Re: Email Notification [message #438596 is a reply to message #438595] Mon, 11 January 2010 02:41 Go to previous messageGo to next message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just do it.

Regards
Michel
Re: Email Notification [message #438611 is a reply to message #438595] Mon, 11 January 2010 03:27 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
So, we know that you want to send emails from the database - the easiest way to do this is the UTL_MAIL package, but if you want to do something more complex, there s also the UTL_SMTP package that lets you write your own emailing code.

You mention a time interval (10 minutes), so presumably you'd like to do something, (probably sending emails) every 10 minutes. Look at DBMS_JOB and DMBS_SCHEDULER for this.

As to the DBA_Scripts part - I'm afraid you'll have to go away and rewrite your post as actual sentences, with some descriptive content in them, before we can be much help there.
Re: Email Notification [message #438612 is a reply to message #438595] Mon, 11 January 2010 03:32 Go to previous message
rahulvb
Messages: 924
Registered: October 2009
Location: Somewhere Near Equator.
Senior Member
Take a look ORAFAQ Post
Previous Topic: Create Materialzed view using WITH clause
Next Topic: Creating more than 1 trigger
Goto Forum:
  


Current Time: Thu Feb 13 17:25:08 CST 2025