Source:Special Schedules: Difference between revisions

From SEPsesam
mNo edit summary
(renewing screenshots)
(36 intermediate revisions by 6 users not shown)
Line 1: Line 1:
== Special Schedules ==
<noinclude>__FORCETOC__


In version 3.4.1.x a special version of programm sm_sepul_event revision 1.183.2.1
<div class="noprint"><languages />
allows to define schedules which will block hourly execution of other schedules related to
<translate><!--T:1-->
the same object.
{{Copyright SEP AG|en}}
The blocking is done during the 'starting time window' of a further defined schedule.
{{Navigation_latest|release=[[Special:MyLanguage/SEP_sesam_Release_Versions|4.4.3 ''Beefalo''/5.0.0 ''Jaglion'']]|link=[[Special:MyLanguage/SEP_sesam_Documentation#previous|documentation archive]]}}</translate></div><br />
<translate>===Overview=== <!--T:2--></translate>


'''Example:'''
{{Additional_Resources_Box|seeAlsoLinks=<translate><!--T:5--> [[Special:MyLanguage/Creating_Custom_Calendar|Creating Custom Calendar]] – [[Special:MyLanguage/About_Scheduling|About Scheduling]] – [[Special:MyLanguage/Creating_a_Schedule|Creating a Schedule]] – [[Special:MyLanguage/SEP_sesam_Events|SEP sesam Events]]</translate>
}}


An hourly scheduled backup for ORACLE with command event 'oracle_XE_full' and Priority '1' is already defined.
</noinclude>
<translate><!--T:10-->
SEP sesam establishes schedules as a framework to which you link different events, such as backup, migration, replication, etc. A schedule defines the recurrence of an event and can be executed in minutes, hours, days, months or years. All schedules and related jobs are configured and run in the time zone of the SEP sesam Server. For more details on scheduling concepts, see [[Special:MyLanguage/4_4_3_Beefalo:SEPuler_-_an_event_calendar|SEPuler – an event calendar]].  


To disallow execution during 12:00 till 14:00 o'clock another schedule, e.g. block_ORACLE_1200-1400, must be defined with
<!--T:11-->
* weekly execution, from Monday till Friday
'''SEP sesam also provides options to prevent activation of individual events on certain days, such as holidays, and at certain hours:'''</translate>
* starting time 12:00 o'clock, duration 2 hours.
*<translate><!--T:12-->
SEP sesam scheduling includes the '''User defined''' option, which allows you to quickly and easily create a custom calendar where you can specify the dates on which you want to run additional jobs or prevent certain jobs from running. For details, see [[Special:MyLanguage/Creating_Custom_Calendar|Creating a Custom Calendar]].</translate>
*<translate><!--T:13-->
Once your custom calendar is set up, you can create a '''blocking event'''. When creating an event use the option '''Blocking date''' in combination with event '''Priority''' in the ''Event properties''.  A blocking event is any type of event that prevents another event of the same type from being activated. It can be specified to prevent the activation of a certain event on certain days or hours. The latter example is shown below. You can also create a blocking event that does not impact only a specific task or task group, but blocks all tasks and you can select which types of events should be blocked. For more information see [[Special:MyLanguage/Newday_Event#blocking|Enabling ''Newday'' to block events]].
For general information on configuring a schedule and linking an event to it, see [[Special:MyLanguage/Standard_Backup_Procedure|Standard Backup Procedure, steps 2 and 3]].</translate>


[[Image:Blocking_schedule_execution_schedule.jpg|center]]
=== {{anchor|configuration}}<translate><!--T:14-->
Configuring a blocking event only for the specified hours ===


This schedule, e.g. block_ORACLE_1200-1400 must be connected to the same command event, e.g. 'oracle_XE_full',
<!--T:15-->
his priority must be higher then the other one, e.g. ''''2''''
A blocking event is created during the configuration of an event or later in the event properties. It is used to prevent the activation of certain events on specific days (e.g., end of year, holidays). It can also be configured to prevent the execution of other jobs related to the same object only within the specified hours.</translate>
and the execution parameter ''''Blocking Date'''' ('Sperrtermin') must be enabled.
{{<translate><!--T:16-->
note</translate>|
*<translate><!--T:17-->
By default, a blocking event suppresses any job with the same task name on the relevant ([[Special:MyLanguage/SEP_sesam_Glossary#backup_day|SEP sesam backup day]]) day, regardless of whether it is scheduled to be run before, during or after the blocking event.</translate>
}}
<translate><!--T:18-->
If you want to set the blocking event to apply only within the specified hours, you must perform some special steps. If you are configuring a blocking event that applies to an entire [[Special:MyLanguage/SEP_sesam_Glossary#backup day|SEP sesam backup day]] (default), see [[Special:MyLanguage/Creating_a_Backup_Event|Creating an Event]].  


<!--T:19-->
To enable the blocking event within the specified hours, the SEP sesam database table ''defaults'' must contain an entry <tt>suppress_with_timerange</tt> with the value <tt>yes</tt>. Without this entry the blocking event prevents related jobs from being activated for the entire sesam day!</translate>
<ol><li><translate><!--T:20-->
Set a SEP sesam profile as described in [[Special:MyLanguage/4_4_3_Beefalo:FAQ#profile_setting|FAQ: What happens when I set a profile]].</translate></li>
<li><translate><!--T:21-->
Once you set the profile, add the following to the SEP sesam database via the command line:</translate></li>
<pre>sm_db "INSERT INTO defaults (key,user_name,value) VALUES ('suppress_with_timerange','sesam','yes');"</pre>
<li><translate><!--T:22-->
The following scenario assumes that you have already defined an ''hourly-scheduled backup for ORACLE'' with the command event ''Oracle all'' and [[Special:MyLanguage/SEP_sesam_Glossary#event priority|event priority]] 1 (default). Now you want to disallow execution from noon till 2 pm. To do this, you need to create another schedule, e.g., ''block_ORACLE_1200-1400''. For details, see [[Special:MyLanguage/Creating_a_Schedule|Creating a Schedule]]. In this schedule you set the recurrence as:</translate>
<ul><li><translate><!--T:23-->
weekly execution, from Monday to Friday</translate></li>
<li><translate><!--T:24-->
starting time 12:00, duration 2 hours</translate></li></ul></li>
<translate><!--T:25-->
[[Image:Blocking_schedule_execution_Apollon.jpg|700px|link=]]</translate>
<br clear=all>
<li><translate><!--T:26-->
You need to link your newly created schedule, in our example ''block_ORACLE_1200-1400'', to the same command event as mentioned above, e.g., ''Oracle_all'' (right-click the schedule and select ''New Command Event''). Browse for the existing event (e.g., ''Oracle_all'') and set the priority to a higher value. Note that this event's priority must be higher than the priority of the linked event. Then enable the '''Blocking date''' option.</translate></li>
<translate><!--T:27-->
[[Image:Blocking_schedule_execution_params_Apollon.jpg|700px|link=]]</translate>
<br clear=all></ol>
<translate><!--T:28-->
If you want to use this function with a regular backup job, keep in mind that the blocking event must refer to the same task name as the backup event.</translate>


[[Image:Blocking_schedule_execution_params.jpg|center]]
 
<noinclude><div class="noprint">
===<translate><!--T:29-->
See also===
[[Special:MyLanguage/Creating_Custom_Calendar|Creating Custom Calendar]] – [[Special:MyLanguage/About_Scheduling|About Scheduling]] – [[Special:MyLanguage/Creating_a_Schedule|Creating a Schedule]] – [[Special:MyLanguage/SEP_sesam_Events|SEP sesam Events]]
 
<!--T:30-->
[[Category:scheduling]]</translate></div></noinclude>

Revision as of 09:39, 2 June 2023


Other languages:

Copyright © SEP AG 1999-2024. All rights reserved.

Any form of reproduction of the contents or parts of this manual is allowed only with the express written permission from SEP AG. When compiling and designing user documentation SEP AG uses great diligence and attempts to deliver accurate and correct information. However, SEP AG cannot issue a guarantee for the contents of this manual.

Docs latest icon.png Welcome to the latest SEP sesam documentation version 4.4.3 Beefalo/5.0.0 Jaglion. For previous documentation version(s), check documentation archive.


Overview


SEP sesam establishes schedules as a framework to which you link different events, such as backup, migration, replication, etc. A schedule defines the recurrence of an event and can be executed in minutes, hours, days, months or years. All schedules and related jobs are configured and run in the time zone of the SEP sesam Server. For more details on scheduling concepts, see SEPuler – an event calendar.

SEP sesam also provides options to prevent activation of individual events on certain days, such as holidays, and at certain hours:

  • SEP sesam scheduling includes the User defined option, which allows you to quickly and easily create a custom calendar where you can specify the dates on which you want to run additional jobs or prevent certain jobs from running. For details, see Creating a Custom Calendar.
  • Once your custom calendar is set up, you can create a blocking event. When creating an event use the option Blocking date in combination with event Priority in the Event properties. A blocking event is any type of event that prevents another event of the same type from being activated. It can be specified to prevent the activation of a certain event on certain days or hours. The latter example is shown below. You can also create a blocking event that does not impact only a specific task or task group, but blocks all tasks and you can select which types of events should be blocked. For more information see Enabling Newday to block events.

For general information on configuring a schedule and linking an event to it, see Standard Backup Procedure, steps 2 and 3.

Configuring a blocking event only for the specified hours

A blocking event is created during the configuration of an event or later in the event properties. It is used to prevent the activation of certain events on specific days (e.g., end of year, holidays). It can also be configured to prevent the execution of other jobs related to the same object only within the specified hours.

Information sign.png Note
  • By default, a blocking event suppresses any job with the same task name on the relevant (SEP sesam backup day) day, regardless of whether it is scheduled to be run before, during or after the blocking event.

If you want to set the blocking event to apply only within the specified hours, you must perform some special steps. If you are configuring a blocking event that applies to an entire SEP sesam backup day (default), see Creating an Event.

To enable the blocking event within the specified hours, the SEP sesam database table defaults must contain an entry suppress_with_timerange with the value yes. Without this entry the blocking event prevents related jobs from being activated for the entire sesam day!

  1. Set a SEP sesam profile as described in FAQ: What happens when I set a profile.
  2. Once you set the profile, add the following to the SEP sesam database via the command line:
  3. sm_db "INSERT INTO defaults (key,user_name,value) VALUES ('suppress_with_timerange','sesam','yes');"
  4. The following scenario assumes that you have already defined an hourly-scheduled backup for ORACLE with the command event Oracle all and event priority 1 (default). Now you want to disallow execution from noon till 2 pm. To do this, you need to create another schedule, e.g., block_ORACLE_1200-1400. For details, see Creating a Schedule. In this schedule you set the recurrence as:
    • weekly execution, from Monday to Friday
    • starting time 12:00, duration 2 hours
  5. Blocking schedule execution Apollon.jpg

  6. You need to link your newly created schedule, in our example block_ORACLE_1200-1400, to the same command event as mentioned above, e.g., Oracle_all (right-click the schedule and select New Command Event). Browse for the existing event (e.g., Oracle_all) and set the priority to a higher value. Note that this event's priority must be higher than the priority of the linked event. Then enable the Blocking date option.
  7. Blocking schedule execution params Apollon.jpg

If you want to use this function with a regular backup job, keep in mind that the blocking event must refer to the same task name as the backup event.