Scheduling SQL

[Johnsf]

Hi,

Does anyone know of any tool available for Windows with which I can schedule some SQL to be run every night and the results be exported to a plain text or csv file?

Cheers,

John

 

[nagornyi]

Oracle Reports 6i server or Oracle 9iAS server both have this functionality. You can create report with plain text or csv output and schedule it as you like. The output can be saved as file or emailed.

 

[Johnsf]

Ive got Oracle9i.... Is it possible to do it with this version? Where can I find instructions on how?

Cheers, John

 

[jaggiebunnet]

You can set up a job using DBMS_JOB that will run some sql in a procedure that writes the output to a text file.

Also you could call the sql from a batch file and have the batch file run from windows scheduling.

 

[sem]

Why don't you use Windows native scheduler at?

Regards, Dima

http://seminihin.narod.ru

 

[Johnsf]

I would use at if I knew how to get it to run a query and dump the results to a file.

 

[sem]

You may create sql*plus script. I can't imagine scheduler that has its own embedded sql interface

Regards, Dima

http://seminihin.narod.ru