How to add commands and scripts to JITL Jobs

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.

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.

The following JITL jobs are relevant to this topic:

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.

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.

See the Job JobSchedulerManagedDatabaseJobSOSHibernate article for an example configuration.

The job executes PL/SQL code for Oracle databases.

This job is used to execute commands, programs and/or shell scripts on a remote server by SSH.