Introduction
Within the JITL features we have some jobs which are used to launch commands.
- One way to define the commands is using the parameter values.
- Another way is to define the statement in the script part of the job instead of the parameter command. All other required parameters remain in the parameter part of the job.
In case that a statement is defined in the script part and also a command parameter is given then the command parameter is used.
Usage
- Add your job to JOE as usual with the Java tab, e.g. by using the job wizard.
- Switch to the Script tab and add the contents that is used as command.
- Alternatively to using the Script tab you could use the Include tab and specify a file from which the content would be included for execution.
Scope
We have these JITL jobs which are involved in this topic:
Job JobSchedulerSSHJob, see Class SOSSSHJob2JSAdapter
JITL Job JobSchedulerManagedDatabaseJob
Class name: sos-berlin.com/doc/JITL/JobSchedulerManagedDatabaseJob.xml
This job executes statements in a database. These can be database procedures or SQL statements. FEATURE AVAILABILITY STARTING FROM RELEASE 1.8
Configuration in JOE
JITL Job JobSchedulerPLSQLJob
Class name sos-berlin.com/doc/JITL/JobSchedulerPLSQLJob.xml
The job executes PL/SQL code for Oracle databases.
Configuration in JOE
JITL JobSchedulerSSHJob
Class name sos-berlin.com/doc/JITL/SOSSSHJob2JSAdapter.xml
This job is used to execute commands, programs and/or shell scripts on a remote server by SSH.
Configuration in JOE