Schedule job to extract data and FTP to other server automatically

We are using Oracle Enterprise Edition 8.1.5 on Solaris and Win NT4. We have to export the month end data into a Tab Delimited File, and to FTP the file to user on monthly basis. Is it possible to program in Oracle (e.g. using PL/SQL, Java Stored Procedure, Specicial Package etc) to perform following tasks automatically on scheduled time after month end:

1. Check Month end flag, defer the job by one day if the flag is off, otherwise continue.
2. Run a query to extract data
3. Save result set as a tab delimited file
4. FTP to user
5. Notify progress status to technical support by Email

Thanks in advance for any advice. Received on Thu Jul 26 2001 - 21:50:09 CDT