Skip to main content
Question

Can I send by email the new record added to a table that is in a database?? thanks

  • October 2, 2019
  • 3 replies
  • 23 views

Can I send by email the new record added to a table that is in a database? and each time there is a new record send me an email

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

3 replies

redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • October 2, 2019

Short answer: yes.

Longer answer: can you tell us a bit more? Are you using FME to add the new records? If so, an Emailer transformer at the end of that workspace should do the trick. Do you want to send an email for every record? How many are you adding per transaction? Per day?


  • Author
  • 4 replies
  • October 4, 2019

Short answer: yes.

Longer answer: can you tell us a bit more? Are you using FME to add the new records? If so, an Emailer transformer at the end of that workspace should do the trick. Do you want to send an email for every record? How many are you adding per transaction? Per day?

No, i am working with a table in Oracle and when a new record is added i need to send that record to a user by email.

redgeographics
Celebrity
Forum|alt.badge.img+60
  • Celebrity
  • 3704 replies
  • October 4, 2019
No, i am working with a table in Oracle and when a new record is added i need to send that record to a user by email.
In that case you need to set up a database trigger that fires after the insert and have that run an external application, which could be FME, sending you an email.