I am using Aginity for connecting to Redshift. My objective is to run a bunch of SQLs on a daily basis and get an email notification upon completion of runs
Using Workbench command line builder, I am able to build a batch .CMD file with my required.sql file. No issues there. In the task notification, I have set up email SMTP server and was able to test if a test email can be sent. All good till this point
However, when I set up email options to Send email "when jobs finishes(error or success)", I could save the option but when I run the job and even after successful job completion, I am not getting an email. The email option is defaulting to Send email " when Job fails" . I opened the .awbcmd file and saved the option I want but it again default to Send email"When job fails".
Any idea how to set the email option to send email when job finishes. I am using aginity version 22.214.171.1241 ( for redshift) and 4.1.1136.21080 ( for netezza)
Note: I have tested the scenario of email when the job actually fails and it works perfectly fine. No issue with aginity talking to my email server, but it just does not save the email option I want
By default below option is saved
I want below option to be saved and reflected so that I can get an email when the job actually is finished running( either success or failure)
Appreciate if anyone of you faced this issue and if you have any solution
Please sign in to leave a comment.