Uploaded image for project: 'JITL - JobScheduler Integrated Template Library'
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-456

Retirement of JITL Job JobSchedulerCleanupSchedulerDbJSAdapterClass



    • Type: Deprecation
    • Status: Deprecated (View Workflow)
    • Priority: Minor
    • Resolution: Deprecated
    • Affects Version/s: None
    • Fix Version/s: 1.11, 1.12
    • Labels:


      Feature Deprecation

      • The JITL Job JobSchedulerCleanupSchedulerDbJSAdapterClass will be replaced with a command line solution described here

      The JobSchedulerCleanupHistory job is critical as it removes entries from the JobScheduler database in parallel to possibly running jobs which frequently creates race conditions.
      Depending on the DBMS in use such race conditions are handled more or less effective. Some DBMS such as SQL Server and MySQL are less than perfect when it comes to row level locking as they tend to restrict a lock to an individual data record and at the same time spread a lock across multiple records from an index which results in lock wait timeouts and possible deadlocks.

      Users who want to shrink their history tables in the JobScheduler database should be enabled to perform such tasks independently of running jobs. Therefore the job implementation should be executable from the command line during maintenance windows when JobScheduler is not up and running.
      The JITL job JobSchedulerCleanupHistory should be executable from the command line and should be accompanied by a shell script for the appropriate parameterization, e.g. use of the configured JVM. The shell script can be executed independently from a JobScheduler instance.

      Deprecation History

      • Release 1.11: Deprecated
      • Release 1.12: Unsupported
      • Release 2.0: Removed




            • Assignee:
              sos_jitl_team TeamJITL
              ur Uwe Risse
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: