...

• 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 SOSPLSQLJobPLSQLJob
  • For Oracle® SQL*Plus use the JS7 - JITL SOSSQLPLUSJobSQLPLUSJob

Usage

When defining the job consider

...