| Table of Contents |
|---|
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 the 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
The following We have these JITL jobs which are involved in relevant to this topic:
Job JobSchedulerManagedDatabaseJob (Release 1.8 to 1.11)
- Job JobSchedulerManagedDatabaseJobSOSHibernate (Release 1.12 and newer)Job JobSchedulerManagedDatabaseJob
Class SOSSSHJob2JSAdapter, ( used in job JobSchedulerSSHJob )Job JobSchedulerSSHJob, see Class SOSSSHJob2JSAdapter
JITL Job JobSchedulerManagedDatabaseJob
Class name: sos-berlin.com/doc/JITL/JobSchedulerManagedDatabaseJob.xml
| Display feature availability | ||
|---|---|---|
|
This job executes statements in a database. These can be database procedures or SQL statements.
The database connection is specified with Job and/or Order parameters.
Configuration in JOE
...
JITL Job JobSchedulerManagedDatabaseJobSOSHibernate
Class name: com.sos.jitl.managed.job.ManagedDatabaseJobJSAdapterClass
| Display feature availability | ||
|---|---|---|
|
This job executes statements in a database. These can be database procedures or SQL statements.
The database connection is specified in a hibernate configuration file.
Configuration instructions
See the Job JobSchedulerManagedDatabaseJobSOSHibernate article for an example configuration.
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 remote server by SSH.For testing of this job the free edition of copSSH is used.
Configuration in JOE
