JITL - JobScheduler Integrated Template Library
  1. JITL - JobScheduler Integrated Template Library
  2. JITL-456

Retirement of JITL Job JobSchedulerCleanupSchedulerDbJSAdapterClass

    Details

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

      Description

      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

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            TeamJITL
            Reporter:
            Uwe Risse
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: