|
|
|
|
|
|
Re: how to generate an email on a database event? [message #507456 is a reply to message #507455] |
Sun, 15 May 2011 15:57 |
ThomasG
Messages: 3211 Registered: April 2005 Location: Heilbronn, Germany
|
Senior Member |
|
|
What do you mean with "Text file resides on client's system" ?
A "text file on a client system" has nothing to do with database events.
I would pick one place where everything takes place. Either
- The Database server
- The Apps server
- The Client
The solution would depend on where you want it to happen.
Also,
Quote:
when user updates a record in a table, a text file including that record will be generated
Why? If the goal is just to send that file via mail, forget about the intermediate step of creating a file. Put the change data directly in a mail. Or into a temporary or log table.
[Updated on: Sun, 15 May 2011 15:57] Report message to a moderator
|
|
|
|
|
|
|
|
|
Re: how to generate an email on a database event? [message #658474 is a reply to message #658455] |
Thu, 15 December 2016 07:32 |
Solomon Yakobson
Messages: 3275 Registered: January 2010 Location: Connecticut, USA
|
Senior Member |
|
|
Mohammed Ayaz wrote on Thu, 15 December 2016 01:16How to send mail whenever job runs successfully
Is it DBMS_SCHEDULER job? If so, use DBMS_SCHEDULER.ADD_JOB_EMAIL_NOTIFICATION. And don't forget to set mail server:
DBMS_SCHEDULER.SET_SCHEDULER_ATTRIBUTE(
attribute => 'email_server',
value => 'your-mail-server:your-mail-server-port'
);
SY.
[Updated on: Thu, 15 December 2016 07:33] Report message to a moderator
|
|
|
|