Date: Tue, 19 Mar 2024 03:11:33 +0000 (UTC) Message-ID: <999377662.19273.1710817893200@change.sos-berlin.com> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_19272_388787127.1710817893200" ------=_Part_19272_388787127.1710817893200 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
page under construction
revision required, a duplicate article might exist
How can I transfer files from a database server to an external server an= d then return them to the database using a middle server?
In particular, I want to know how to invoke remote script and database p= rocedure? I checked the document in your official website but didn=E2=80=99= t get any clue about this. Can JobScheduler fulfill our requirement?
There are several ways to implement such a scenario.
A typical workflow would be to use a single JobScheduler installed on th= e middle server with a job chain with several steps:
Step (1) start the database report. You can use the SQL*Plus, PL/SQL= a> or the ManagedDatabase= a> jobs from the JITL package.<= /p>
existsFile
job from the JITL package.Step (5) Use SFTP and the YADE job to transfer the result of step (4= ) to the middle server.