Connection tests of SQL Jobs fail when database information (host and db name) is entered in the Job and a Login object is used.
The Job itself runs without errors, and the this issue does not occur when an SQL Connection object is used. Connection tests now run correctly.
Error message:
Connection test failed - 2018-05-02 20:26:20 - U02012031 The database driver returned the following error message: 2018-05-02 20:26:20 ORA-01017: invalid username/password; logon denied 2018-05-02 20:26:20 - U02004025 Job-script execution was aborted.