Pentaho generic error handling script

Question

At this moment I am trying to make a generic error handling script using Pentaho. So far I've found some information about Shell scripts but they do not seem to work for me.

What I want to create is a script (Shell or whatever) that can send messages through Gmail or Hipchat with information about the error and what went wrong. This has to be a generic step so that it can easily be placed in any other job.

Does anyone have ideas? I can't find much (dated) information about Pentaho at all through Google.

I have also tried sending E-mail but for some reason I just get an E-mail containing what was done, not with the errors I get?

The shell script I found is listed below, however it does not seem to be sending E-mail:

#!/bin/sh

OUTDIR=/pentaho/spoon/data-integration/Backup/FCP_DEL_ALL.out
v_jobfile=/pentaho/spoon/data-integration/production_reports/XYZ.kjb

/pentaho/spoon/data-integration/kitchen.sh \
-file="$v_jobfile" -level=Minimal > $OUTDIR
if [ $? -eq 0 ];
then
echo "The Program Completed Successfully(KAAS) :-" >> $OUTDIR
else
mail -s "TRF NAME ERROR" mick.vanhulst@gmail.com -c mick.vanhulst@gmail.com < /pentaho/spoon/data-integration/Backup/FCP_DEL_ALL.out
fi

Answer 1

Try setting the level to Error. By this way, only error messages would be written to log file. Also, use -log option. Also, instead of checking return code of kitchen.sh, check whether log file is empty.

OUTDIR=/pentaho/spoon/data-integration/Backup/FCP_DEL_ALL.out
v_jobfile=/pentaho/spoon/data-integration/production_reports/XYZ.kjb

/pentaho/spoon/data-integration/kitchen.sh \
-file="$v_jobfile" -level=Error -log="$OUT_DIR"
if [ -z "$OUTDIR" ];
then
echo "The Program Completed Successfully(KAAS) :-" >> $OUTDIR
else
mail -s "TRF NAME ERROR" mick.vanhulst@gmail.com -c mick.vanhulst@gmail.com < /pentaho/spoon/data-integration/Backup/FCP_DEL_ALL.out
fi