Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Step (1) start the database report. You can use the SQL*Plus, PL/SQL or the ManagedDatabase jobs from the JITL package.

  • Step (2) check the size/existence/content of the output from step 1 using the existsFile job from the JITL package.
  • Step (3) transfer the file from the middle server to the external one using, for example, SFTP and the JADE - Job from the JITL package.
  • Step (4) start the processing on the external server using SSH.
  • Step (5) Use SFTP and the JADE job to transfer the result of step (4) to the middle server.

  • Step (6) Start the processing of the result file using, for example, SQL*Plus or PL/SQL.

...