Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: 'JobSchedulerManagedDatabaseJobSOSHibernate' added

...

  • 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

We have these The following JITL jobs which are involved in relevant to this topic:

...

Class name:  sos-berlin.com/doc/JITL/JobSchedulerManagedDatabaseJob.xml

Display feature availability
StartingFromRelease1.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


Image Added

JITL Job JobSchedulerManagedDatabaseJobSOSHibernate

Class name:  com.sos.jitl.managed.job.ManagedDatabaseJobJSAdapterClass

Display feature availability
StartingFromRelease1.8

Configuration  in JOE

Image Removed

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

...