In Toad for Oracle, I have set up my SMTP info and a username and password are required. I can run the E-mail Test and it's successful.
However in the automation designer, when I set up an E-mail activity, the SMTP seems carries over, but no visible sign where to put the user and password is available. Thus when trying to test run the e-mail task in automation, I gets the following error:
161 SMTP protocol error 550 relaying not allowed
I tried to put the username and password within the SMTP field as such:
It looks like it's trying something, but then we get a Connection Time out.
STATUS: Waiting for fix in a future release of Toad for Oracle.
The SMTP settings in the e-mail action (Automation designer) and the global Toad options are completely independent of each other. Unfortunately the SMTP settings in the e-mail action in the automation designer does not support user name/password.