1 Reply Latest reply: Jul 16, 2012 4:59 PM by Rnr-Oracle RSS

    transfer files

    933651
      Hello everybody!

      Is there a way to create a job to transfer files from linux to windows with a scheduled job where the name of the file is given as a parameter.
      The job will execute a linux shell script(for transferring) only once.
      So the job must not be scheduled but run on every call.

      Thanks in advance!

      Edited by: 930648 on Jun 28, 2012 2:21 AM
        • 1. Re: transfer files
          Rnr-Oracle
          Hi,

          You can do this in one of 2 ways.

          - setup a scheduler remote agent on the windows host. Use a pl/sql stored procedure dbms_scheduler job which calls dbms_scheduler.put_file

          - setup an external script dbms_scheduler job which calls a script which uses scp or ftp to transfer the file

          Thanks,
          Ravi.