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 the case that a statement is defined in the script part and also a command parameter is given then the command parameter is executed. To show this priority we define an illegal command parameter and the correct version within the script part.A second test without the command parameter shows the correct execution of the statement defined in the  script part.

We have these JITL jobs which are involved in this topic:

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:

• Job JobSchedulerManagedDatabaseJob (Release 1.8 to 1.11)

• Job JobSchedulerManagedDatabaseJobSOSHibernate (Release 1.12 and newer)

• Job JobSchedulerPLSQLJob

• Job JobSchedulerSSHJob, see Class SOSSSHJob2JSAdapter

• Job  JobSchedulerManagedDatabaseJob

• Job JobSchedulerPLSQLJob

• Class SOSSSHJob2JSAdapter, ( used in job JobSchedulerSSHJob )

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

Error execution

Image Removed

This configuration causes the error: java.lang.Exception cannot be cast to com.sos.JSHelper.Exceptions.JobSchedulerException

Correctly executed

After the deletion of the command parameter the statement defined in the script part is executed correctly. 

. 

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. Image Removed

JITL Job JobSchedulerPLSQLJob

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

The job executes PL/SQL code for oracle Oracle databases.

Error execution

Image Removed

 This configuration causes an error stop with : ERROR [main] (JobSchedulerPLSQLJob.java:109) - SQL Exception raised. Msg='ORA-00900: Ungültige SQL-Anweisung

Correctly executed

When the command parameter is deleted the job is executed correctly

Image Removed

Configuration  in JOE

Image Added

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

Image Added