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

Enable JobSchedulerCleanupHistory job to be executed from the command line

    XMLWordPrintable

Details

    • Feature
    • Status: Released (View Workflow)
    • Major
    • Resolution: Fixed
    • None
    • 1.9.11, 1.10.4, 1.11
    • None

    Description

      Current Situation

      • 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.

      Desired Behavior

      • 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.

      Attachments

        Issue Links

          Activity

            People

              ur Uwe Risse
              ap Andreas PĆ¼schel
              Oliver Haufe Oliver Haufe
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - 1 hour
                  1h
                  Remaining:
                  Remaining Estimate - 1 hour
                  1h
                  Logged:
                  Time Spent - Not Specified
                  Not Specified