For the OP, saikrish.cherukuri, you need to read through the output and limit it to the failed part of the job. I doubt there's much in here, so you need to provide the way you called this and also what happens if you call that part alone as a SQL session.