I have scheduled some tasks through automation designer. I would like to send an e-mail if certain task failed. I am able to achieve and get an e-mail in case of failure. What I am looking in addition to that, in execution log I can see the reason of fail. I would like to send this reason in the body of e-mail. Instead of toadactions.log file attachment in the e-mail.
We have scheduled many scripts and running after every an hours. Currently if any task failed, we need to go to Toad manually and check the execution log to know the reason of fail. I would be much easier if we get the reason in the e-mail of the body.
Thanks & Regards,
Sohail