Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: Send Email Based On Query Output

Send Email Based On Query Output 6 years 4 months ago #9796

  • Charles
  • Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 28
  • Thank you received: 0
Hi,

My requirement is that if count(*) from source table is >0, then trigger email, else do not send email. Is there any way I can handle this using your software or any suggested way to achieve this?

Please advise.
Thanks,
Charles

Please Log in or Create an account to join the conversation.

Send Email Based On Query Output 6 years 4 months ago #9797

  • admin
  • admin's Avatar
  • Offline
  • Moderator
  • Moderator
  • Deeds not Words
  • Posts: 7839
  • Karma: 33
  • Thank you received: 472
Ten minutes job.

1.Install Visual importer Enterprise
2. Create new project
3. Crete database connection
4. Create smtp connection
5. Create sql script to check the number of records
6. Create new package
7. Add check sql object and use sql script created as step 5 as data sourse
8. Add send email object
9. Link objecs
10. job is done

Mike
Mike

Please Log in or Create an account to join the conversation.

  • Page:
  • 1

We have 223 guests and one member online