Source:Special Schedules: Difference between revisions
No edit summary |
|||
Line 1: | Line 1: | ||
== Special Schedules == | == Special Schedules == | ||
In version 3.4.1. | 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 table defaults must contain an entry "suppress_with_timerange" with value "yes". Without this entry the blocking is done for the whole sesam day. | To enable this the table defaults must contain an entry "suppress_with_timerange" with value "yes". Without this entry the blocking is done for the whole sesam day. |
Revision as of 10:30, 31 July 2012
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 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)
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', his priority must be higher then the other one, e.g. '2' and the execution parameter 'Blocking Date' ('Sperrtermin') must be enabled.