Re: Is a scheduled job posisble to output spool file

1 You can use spool, using the scheduling facilities of your O/S: Cron on Unix, task scheduler on Winblows
2 In you convert to dbms_job you need to use the UTL_FILE package. Before you can do that, you need to set up a directory on the server, by using the CREATE DIRECTORY command (9i and higher), or change the parameter utl_file_dir, and bounce the database (all versions, unless paleolithic).

-- 
Sybrand Bakker
Senior Oracle DBA