Is a scheduled job posisble to output spool file

Hi,

I have a sql to retrieve records from the database, and I spool the output into a file at the beginning of the sql. The spooling works fine when I manually run the sql in Sql*plus.

I am thinking to schedule this sql as a daily job using DBMS_JOBS package in Oracle 9i, but somehow I have the feeling that the spool won't work once it is scheduled. This is the first time I do this kind of things, so probably some guys can help a bit.

In case the spooling output to a file doesn't work in scheduled jobs, what other ways for me to output the records to a text file?

Thanks.

-- 
warren