Re: Schedule job to extract data and FTP to other server automatically

Yes, I believe so. Look in the manuals under the pl/sql supplied packages. there is utl_smtp (for sending email)
there is utl_tcp (which could send email or ftp, etc.) there is dbms_jobs for scheduling jobs in the database.

I wouldn't neccessarily create a tab delimited file, maybe just send it directly via ftp. but you can use utl_file to create a file.

Of course, I can think of other ways also, but those should work. Jim
"Andy Yu" <takchoiyu_at_home.com> wrote in message news:3B60D69F.E62F64A_at_home.com...
> 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 - 22:16:24 CDT