You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »

The JobScheduler stores for each task and order its log into the database tables

  • SCHEDULER_HISTORY
  • SCHEDULER_ORDER_HISTORY
  • SCHEDULER_ORDER_STEP_HISTORY

The job sos/dailyschedule/CreateDaysSchedule (before JobScheduler release 1.11) stores records into the database table

  • DAYS_SCHEDULE

The job sos/dailyplan/CreateDailyPlan (since JobScheduler release 1.11) stores records into the database table

  • DAILY_PLAN

The job sos/jade/jade_import stores records into the database table

  • JADE_FILES
  • JADE_FILES_HISTORY

The job sos/jade/ReportingFacts (before JobScheduler release 1.11) stores records into the database tables

  • REPORT_*

The plugin com.sos.jitl.reporting.plugin.FactPlugin (since JobScheduler release 1.11) stores records into the database tables

  • REPORTING_*

If nobody cares, then these tables are very large and the performance goes down or there is no more space available.

To avoid this, you should regularly run ...

  • the job /sos/housekeeping/scheduler_cleanup_history (before JobScheduler release 1.11)
    • If you choose the 'Housekeeping' package during the installation then you find this job in ./config/live/sos/housekeeping/scheduler_cleanup_history.
  • the scripts
    • ./bin/cleanup_jobscheduler_tables.(sh|cmd)
    • ./bin/cleanup_reporting_tables.(sh|cmd)

Parameterization of cleanup scripts (since release 1.11)

  • The scheduler_cleanup_history job is not longer included in the setup of the JobScheduler since release 1.11.
  • Further the setup knows two databases; the JobScheduler database and the Reporting database.

./bin/cleanup_jobscheduler_tables.(sh|cmd)

  • This script cleans the database tables
    • SCHEDULER_HISTORY
    • SCHEDULER_ORDER_HISTORY
    • SCHEDULER_ORDER_STEP_HISTORY
  • It expects the database connection setting in ./config/hibernate,cfg.xml.
  • This script has only one argument for the age of the records.
    • All records older then the specified age are removed.
  • If this script is called without an argument then you get its usage

    Usage: cleanup_jobscheduler_tables.(sh|cmd) age          | age : Age of table entries
    Example: - Remove entries older than 14 days then call
               cleanup_jobscheduler_tables.cmd 14
             - Remove all entries then call
               cleanup_jobscheduler_tables.cmd 0

./bin/cleanup_reporting_tables.(sh|cmd)

  • This script cleans the database tables
    • DAILY_PLAN
    • JADE_FILES
    • JADE_FILES_HISTORY
    • REPORTING_*
  • It expects the database connection setting in ./config/reporting_hibernate,cfg.xml.
  • This script has two arguments for the age of the records and for the range of the tables.
    • All records older then the specified age are removed.
    • You can filter the tables in which the records will be removed with the range argument. Possible values are all, reporting, dailyplan or yade.
  • If this script is called without an argument then you get its usage

    Usage: cleanup_reporting_tables.(sh|cmd) range age
           range           | which tables? all, reporting, dailyplan, yade
           age             | Age of table entries
    Example: - Remove entries older than 14 days in all tables then call
               cleanup_reporting_tables.cmd all 14
             - Remove entries older than 14 days in reporting tables then call
               cleanup_reporting_tables.cmd reporting 14
             - Remove all entries then call
               cleanup_reporting_tables.cmd all 0

Parameterization of scheduler_cleanup_history job (before release 1.11)

This job deletes records which are older than the parameter delete_interval

 <?xml version="1.0" encoding="iso-8859-1"?>
 
 <job title = "Delete log entries in Job Scheduler history">
 
    <description>
       <include file = "jobs/JobSchedulerCleanupHistory.xml"/>
    </description>
     
    <params>
      <param name = "delete_interval" value = "7" />
    </params>
    
    <script language      = "java"
            java_class    = "sos.scheduler.job.JobSchedulerCleanupHistory"/>
    
    <!-- cleanup history entries every day of the week at the given hour -->
    <run_time let_run = "yes"
              begin   = "00:00"
              end     = "24:00">
       <period single_start = "01:00"/>
    </run_time>
 
 </job>

Parameterization of scheduler_cleanup_history job (before release 1.3.12.1285)

 <?xml version="1.0" encoding="iso-8859-1"?>
 
 <job title = "Delete log entries in Job Scheduler history">
 
    <description>
       <include file = "jobs/JobSchedulerCleanupHistory.xml"/>
    </description>
     
    <params>
      <!-- buggy: value=0 selects all records for cleanup -->
      <!--param name = "cleanup_history_interval" value = "0" /-->
      <!-- workaround: value=1 selects max. only one record for cleanup -->
      <param name="cleanup_history_task_id" value="1"/>
      <!-- workaround: value=1 selects only one record for cleanup -->
      <param name="cleanup_history_order_id" value="1"/>
      <!-- example: value=7 deletes all records older than 7 days -->
      <param name = "delete_history_interval" value = "7" />
    </params>
    
    <script language      = "java"
            java_class    = "sos.scheduler.job.JobSchedulerCleanupHistory"/>
    
    <!-- cleanup history entries every day of the week at the given hour -->
    <run_time let_run = "yes"
              begin   = "00:00"
              end     = "24:00">
       <period single_start = "01:00"/>
    </run_time>
 
 </job>
  • No labels