dbms_job

[bxr556]

can i do something like this:

variable jobno number;
variable instno number;
begin
dbms_job.submit(:jobno,' host copy /u01/app/oracle/file1 /u02',sysdate);
end;

if so, how?

[jdorlon]

Unfortunately the HOST command only works from SQL Plus.
If you want to schedule the copying of a file, it would be easier to do it from an OS scheduler like CRON.

-John