...

• The job template makes use of JDBC connections and the Hibernate database access layer.
• The job template can be used to access any database for which a JDBC Driver is available with the Agent.
  • The JS7 includes a number of JDBC Drivers for supported DBMS, see JS7 - Database.
  • For other DBMS you can provide an individual JDBC Driver and store the Driver's .jar file with the ./lib/user_lib directory of the Agent installation.
• Delimitation
  • Consider that specific SQL language extensions such as e.g. Oracle® PL/SQL are not supported by Hibernate.
  • For Oracle® PL/SQL use the JS7 - JITL SOSPLSQLJob
  • For Oracle® SQL*Plus use the JS7 - JITL SOSSQLPlusJob

...

• • SOSSQLPLUSJob

Usage

When defining the job consider

• to select the JITL job class and
• to specify the com.sos.jitl.jobs.db.SQLExecutorJob Java class name.

Image Added

The job arguments can be specified as follows:

Image Added

Arguments

The com.sos.jitl.jobs.db.SQLExecutorJob class accepts the following arguments:

...