I would recommend using Automation Designer for this.
There was a post recently that was very similar to this…
From: HanGyo Jung [mailto:firstname.lastname@example.org]
Sent: Wednesday, August 14, 2013 3:27 AM
Subject: [Toad for Oracle - Discussion Forum] How can I append output on the existing file using export dataset option
Thread created by HanGyo Jung
I’m using 11.5 version of Toad for Oracle.
I do daily check about 15 databases(more in the future) using Toad with same sql scripts.
I configured Auto Connect on login windows. So when I start Toad I see 15 databases connected on the Connection Bar.
And I open a sql file in the Editor. I do this 15 times on the each databases.
We have a Excel format to make a report. So each database I execute the sql and Copy / Paste from the Output Grid to Excel.
You know what I’m doing and It is too much wasting time.
The Excel Sheet format like this
db1 | data | data | data …
db2 | data | data | data …
db3 | data | data | data …
So What I want to do is like below :
Execute a sql on the fist server. Output will be created a csv file.
Execute same sql on the second server. Output will be appended an existing csv file from the above.
Execute same sql on the third server …
What is the best way to minimize typing keyboard or clicking mouse.
Thanks in advance.
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
this post as spam/abuse.