In Toad 16, is it possible to run one command from editor on several instances, like in Microsoft SSMS ?
No. Execution is only performed on the active connection tied to that Editor. If this is something you need to do periodically with a relatively static set of SQL you should checkout the Script Manager and Automation Designer, both available from the Utilities menu. Both allow for execution of scripts across multiple databases.
Was just going to reply to the same effect... Best thing we can do for your use case of running multiple scripts/queries/commands on multiple connections...see screen snap below...
And of course, as Michael just said, the Automation Designer is another place where you can loop through a list of connectors to execute script/command logic. Thanks for the reminder, Michael!
Did anyone try to test the Automation Designer to loop through a list of connectors to execute script/command logic?
Yes. You can create an app with a Connection Iterator (see the Control) tab and then you can place an Execute Script action (see the DB Misc tab) beneath it. Configure the Connection Iterator so that your connections are defined that you want to run your command against. Then setup the script action and run the app.
How can I read the output log script execution for each connection?
