Page History

Table of Contents

	outlinh1. true
	outlinh1. true
1	printablefalse
2	stylh1. none
3	indent20px

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

...

To avoid this, you should regularly run this job.
If you choose the 'Housekeeping' package while the installer then you find this job in ./config/live/sos/housekeeping/schedulercleanupcleanup_historyhistory_.

This job can

...delete logs which are older than the parameter delete_history_interval
...shrink log entries (remove debug lines) which are younger than the parameter cleanup_history_interval

The second function is very time consuming and generates a lot of payload.
Here, when many records are processed, it can even cause the error

Code Block


 COM 80020009 Exception occurred. [step] [] [Z-JAVA-105 Java exception java.lang.OutOfMemoryError ("Java heap space"), method = spooler_process () Z [], in Remote_module_instance_server :: step], method = call

<span style="color:red">It is strongly recommended that you suppress the shrink functionality and uses only the delete functionality.</span>

Parameterization of JobSchedulerCleanupHistory since release 1.3.12.1285

Code Block


 <?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>
      <span style="color:red">&lt;<!-- strongly recommended: value=0 suppresses the cleanup --&gt;>
      '''<param name = "cleanup_history_interval" value = "0" />'''</span>
      &lt;<!-- example: value=7 deletes all records older than 7 days --&gt;>
      <param name = "delete_history_interval" value = "7" />
    </params>
    
    <script language      = "java"
            java_class    = "sos.scheduler.job.JobSchedulerCleanupHistory"/>
    
    &lt;<!-- cleanup history entries every day of the week at the given hour --&gt;>
    <run_time let_run = "yes"
              begin   = "00:00"
              end     = "24:00">
       <period single_start = "01:00"/>
    </run_time>
 
 </job>

Parameterization of JobSchedulerCleanupHistory before release 1.3.12.1285

Code Block


 <?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>
      <span style="color:red">&lt;<!-- buggy: value=0 selects all records for cleanup --&gt;>
      &lt;<!--param name = "cleanup_history_interval" value = "0" /--&gt;>
      &lt;<!-- workaround: value=1 selects max. only one record for cleanup --&gt;>
      '''<param name="cleanup_history_task_id" value="1"/>'''
      &lt;<!-- workaround: value=1 selects only one record for cleanup --&gt;>
      '''<param name="cleanup_history_order_id" value="1"/>'''</span>
      &lt;<!-- example: value=7 deletes all records older than 7 days --&gt;>
      <param name = "delete_history_interval" value = "7" />
    </params>
    
    <script language      = "java"
            java_class    = "sos.scheduler.job.JobSchedulerCleanupHistory"/>
    
    &lt;<!-- cleanup history entries every day of the week at the given hour --&gt;>
    <run_time let_run = "yes"
              begin   = "00:00"
              end     = "24:00">
       <period single_start = "01:00"/>
    </run_time>
 
 </job>

Space shortcuts

Page tree

Versions Compared

Old Version 3

New Version 4

Key

Parameterization of JobSchedulerCleanupHistory since release 1.3.12.1285

Parameterization of JobSchedulerCleanupHistory before release 1.3.12.1285