Need to create an alert email notification when the Orchestration job fails with the error message.
We are trying to capture the error message and call a snaowflake procedure to send an alert email, but not able to achiev it and Variables messages are not getting captured as expected.
Hello @samatha.marreddy
Thank you for your post, and a warm welcome to the Matillion Community.
There are two options here, one would be to attach the send email component in the failure node of the run orchestration, another would be to use the variable detailed_error to embed the error.
Here are some helpful docs that will help you achieve either of these approaches.
Automatic Variables
Send Email Component
If you need anything else, please do not hesitate to ask.
Kind regards, Joe