Toad World® Forums

auto send query results to text file


#1

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.


#2

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


#3

Here are some links to read:

www.toadworld.com/…/quick-intro-to-toad-command-line.aspx

www.toadworld.com/…/automated-toad-db-health-check-via-email.aspx

www.toadworld.com/…/automated-toad-db-health-check-via-email-part-2.aspx


#4

and a one more:

www.toadworld.com/…/task-automation-in-toad-174-saving-you-hours.aspx


#5

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