auto send query results to text file

Toad for Oracle & DevOps Toolkit
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!