I have a SQL script, which spools the output to a txt file.
Can I use DBMS_JOBS utility so as to set this script run in specified intervals..?

What I heard from someone is that, only Stored Procedures can be set as jobs in DBMS_JOBS.

If so, I would like to know how to spool the output of a sql query to a txt file using a PL/SQL script.

Thanks

VG