Toad World® Forums

automate exporting query results to a text file

I’ve just transfered into a group that uses toad for oracle, so, I’m brand new to toad (used sql server and access before). We’re using toad 9.5.

I want to schedule a daily export from a query to a text file. Is the only way to do this (using toad) via the action pallet and then set up a schedule? (I was thinking a command line instruction might work and then use the windows task scheduler - toad is running on a win 2003 server).

Also, I tried searching the forum on words like export, command and got zip results. Surely there must be some posts about those subjects.

thanks
alan