Hi Mat,
Yes, in Automation Designer, if you use the ‘Export Dataset’ action, you simply put your query on the Dataset tab (no need to include the connect string),
and then on the options tab select the format you want to export it to (Excel, HTML, etc.). For the connection part - in the upper left hand corner there is a connection button that will control what database it is run on. Add multiple actions for the different
db’s you want to run your queries on.
So, if you want to run it on multiple databases do the following:
-
Add ‘Export Dataset’ app
-
Set the connection to the database you want. Set the output options. Paste your query.
-
Add another ‘Export Dataset’ app
-
Set the connection to another database you want. Set the output options. Paste your query.
– Repeat for all databases and queries you want
Then to run, you can…
-
Run the whole app and it will produce all your output files in one run
-
Run the individual actions as you want
-
Or schedule the App/actions to run automatically whenever is best for you, even if you are not at your computer.
The little script I sent before is only if you don’t care about format and to give you an example of how the same query can be run on multiple db’s using
a script. I recommend using the AD for the best results and ease of use. It’s a very powerful tool.
Hope this helps,
Dennis
From: tendrills [mailto:bounce-tendrills@toadworld.com]
Sent: Wednesday, July 31, 2013 5:26 AM
To: toadoracle@toadworld.com
Subject: RE: [Toad for Oracle - Discussion Forum] Set Reports Manager on multiple databases ?
RE: Set Reports Manager on multiple databases
?
Reply by tendrills
Hi Dennis and Bert, thank you very much, it worked !
But if I may ask, is there any way to get the results in a “beautiful” pdf, using a Report Def File or something ?
Because my only output is a txt file.
Or maybe a way to call a report from reports manager in an app in automation designer ?
Mat
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad for Oracle - General notifications altogether.
Toad for Oracle - Discussion Forum
Flag
this post as spam/abuse.