Source:Special Schedules: Difference between revisions

From SEPsesam
Line 6: Line 6:
(Since sm_sepul_event revision 1.188)
(Since sm_sepul_event revision 1.188)


After setting the profile at the commandline, this value may be inserted with:
After setting the [[English_FAQ#What_happens_when_I_set_a_profile.3F|profile]] at the commandline, this value may be inserted with:
  sm_db "INSERT INTO defaults (key,user_name,value) VALUES ('suppress_with_timerange','sesam','yes');"
  sm_db "INSERT INTO defaults (key,user_name,value) VALUES ('suppress_with_timerange','sesam','yes');"



Revision as of 18:20, 16 February 2016

Special Schedules

In version 3.4.1.x or higher it's possible to define 'Blocking Date' schedules which will block execution of other schedules related to the same object where the blocking is done only during the 'starting time window' of the 'Blocking Date' schedule with higher priority.

To enable this, the Sesam database table defaults must contain an entry "suppress_with_timerange" with value "yes". Without this entry the blocking is done for the whole sesam day. (Since sm_sepul_event revision 1.188)

After setting the profile at the commandline, this value may be inserted with:

sm_db "INSERT INTO defaults (key,user_name,value) VALUES ('suppress_with_timerange','sesam','yes');"

Example:

An hourly scheduled backup for ORACLE with command event 'oracle_XE_full' and Priority '1' is already defined.

To disallow execution during 12:00 till 14:00 o'clock another schedule, e.g. block_ORACLE_1200-1400, must be defined with

  • weekly execution, from Monday till Friday
  • starting time 12:00 o'clock, duration 2 hours.



This schedule, e.g. 'block_ORACLE_1200-1400' must be connected to the same command event, e.g. 'oracle_XE_full'. Its priority must be higher than the other one, e.g. '2' and the execution parameter 'Blocking Date' ('Sperrtermin') must be enabled.



When you want to use this function with a regular backup job keep in mind that the blocking event has to reference the same task name as the backup event does.