Hitachi Vantara Pentaho Community Forums
Results 1 to 2 of 2

Thread: Sending email when i get error while loading table

  1. #1
    Join Date
    Sep 2012
    Posts
    25

    Default Sending email when i get error while loading table

    Hi,

    i am loading data to table using spoon. if any records rejected or if any errors occur, i want to send an email.
    How can i do this? id i use a mail step after the Table output, it will write all the error records in the email. i dont want to do this, because if there are million errors for some reason, i dont want to bring down the mail server.

    Thanks for your help

  2. #2
    Join Date
    Mar 2011
    Posts
    19

    Default

    Hi,

    There are a few options:

    1. I like this way: put a Blocking Step in the error stream between the table input emitting errors and the email step. The blocking step will just send through one - the last - error row to the email step and you'll just get the one email sent whether it's many or one error.

    2. have the error step set a variable and in a subsequent transformation, check the variable and send an email if needed

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.