My organization has merged and I know have two logins with database access with under both accounts. To switch to my secondary database I select “Run a different user” when I open Toad Data Point, which works fine for ad-hoc querying. I would like to automate reports from my secondary database.
I can schedule my automation to run if I use my primary account on the windows scheduler but Toad can’t find the database connection and my automation fails. Is there some other way that I can access my secondary database under my primary account so that I can automate reports?