Skip to end of metadata
Go to start of metadata

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 this topic:

JITL Job JobSchedulerManagedDatabaseJob

Class name:  sos-berlin.com/doc/JITL/JobSchedulerManagedDatabaseJob.xml FEATURE AVAILABILITY STARTING FROM RELEASE 1.8

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 FEATURE AVAILABILITY STARTING FROM RELEASE 1.12

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 server by SSH.

Configuration  in JOE