auto send query results to text file

denise.mcmillan_484 · July 30, 2014, 1:38pm

Is there a way in TOAD for Oracle to create a scheduled job that will run a query and send the results somewhere as a text file?

Thanks for any ideas.

Bert_Scalzo · July 30, 2014, 1:49pm

Yes - read the online help or toad world blogs about the toad app designer and scheduling such apps.

Bert_Scalzo · July 30, 2014, 1:56pm

Here are some links to read:

Bert_Scalzo · July 30, 2014, 1:59pm

and a one more:

denise.mcmillan_484 · July 30, 2014, 2:16pm

Thanks for all the great ideas and links I’ll be exploring the possibilities!

Topic		Replies	Views
query output to text file Toad for Oracle	0	595	June 30, 2012
auto run oracle query and send results as text file Toad Data Point & Toad Intelligence Central	4	2152	August 27, 2014
automate exporting query results to a text file Toad for Oracle	0	661	August 7, 2011
Schedule Email with Query Output Attached Toad for Oracle	2	2285	April 2, 2020
Job for Daily Reporting Toad for Oracle	6	1173	November 4, 2020