sending email automatically from oracle [message #354066] |
Thu, 16 October 2008 05:55 |
suneelreddy
Messages: 11 Registered: May 2008 Location: india
|
Junior Member |
|
|
Hello All,
Can we send a email automatically if a value in a table changes using SMTP?
For example
If a value of table t1 & column c1 changes .we need to send a mail automatically .
By using UTL_SMTP we can send a mail. but i am not sure whether we can send it automatically or not.PLs guide me or provide the links that cover about sending mails from oracle automatically.
Thanks in Advance,
Suneel Reddy.R
|
|
|
|
Re: sending email automatically from oracle [message #354074 is a reply to message #354070] |
Thu, 16 October 2008 06:21 |
suneelreddy
Messages: 11 Registered: May 2008 Location: india
|
Junior Member |
|
|
Hi Thomas,
That table contains only one row .Updates are very rare for that coulumn.Let me say you the requirement that table stores the information of the application srv status.My requirement is to send a mail to support teams if primary application server is down.The application will run on secondary.My requirement is to send a mail to support teams that Appserver 1 is stopped.
This happens very rare approx once in a quarter or so.
But this is required as they have to change some schedulers if primary is down.
Is the requirement clear .
Any have i will study the links provided by you.
If you can help more .PLs.
Thanks for the reply
Regards
Suneel Reddy .R
|
|
|
Re: sending email automatically from oracle [message #354123 is a reply to message #354074] |
Thu, 16 October 2008 08:30 |
ThomasG
Messages: 3212 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
In that case it should work that way.
There are examples in the documentation, try them and post what you tried and the problem (the entire relevant SQL*Plus Session when applicable) in case you get stuck at some point.
|
|
|