How to read the Failure message from Tranformation Job?
I’ve a requirement to send failure email notification through SNS Message component. In the email message I’d like to include reason of the failure. I’ve created Orchestration job and within that I’m using Transformation job. The Orchestration job components looks like this start -> Transformation job -> SNS message -> End Failure. I’ve used Export variable option in Run Transformation component to export the “Message” of Transformation component to a job variable. The email is getting triggered but in the email message I couldn’t able see the reason for the error. I want to include the exact failure reason of the Transformation job, how can I do that?