Page History

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

The following JITL jobs are relevant to We have four JITL jobs which are involved in this topic:

• Job JobSchedulerManagedDatabaseJob (Release 1.8 to 1.11)

• Job JobSchedulerManagedDatabaseJobSOSHibernate (Release 1.12 and newer)

• Job JobSchedulerPLSQLJob

• Job JobSchedulerSSHJob, see Class SOSSSHJob2JSAdapter

• Class SOSSSHJob2JSAdapter, ( used in job JobSchedulerSSHJob )

• ??

JITL Job JobSchedulerManagedDatabaseJob

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. 

The database connection is specified with Job and/or Order parameters.

Configuration  in JOE

Image Added

JITL Job JobSchedulerManagedDatabaseJobSOSHibernate

Class name:  com.sos.jitl.managed.job.ManagedDatabaseJobJSAdapterClass

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. Class name sos.scheduler.managed.JobSchedulerManagedDatabaseJob

JITL Job JobSchedulerPLSQLJob

Class name sos.scheduler.db.JobSchedulerPLSQLJobJSAdapterClass -berlin.com/doc/JITL/JobSchedulerPLSQLJob.xml

The job executes PL/SQL code for Oracle databases.

Configuration  in JOE

Image Added

JITL JobSchedulerSSHJob

Class namesos.scheduler.job.SOSSSHJob2JSAdapter-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

Image Added