16.20 - 16.50 - Example: Wrap around Midnight - Teradata Viewpoint - Teradata Workload Management

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
16.20
16.50
Release Date
July 2021
Content Type
User Guide
Publication ID
B035-2206-071K
Language
English (United States)

When creating period events, use the Wrap around midnight option to have a time frame spanning midnight.

If the From time of a period event is later than the To time, two time segments are available: midnight until the To time and the From time until midnight. When Wrap around midnight is not selected, the period event is in effect for segment 1 and segment 2 on each specified day. When Wrap around midnight is selected, the event is in effect for segment 2 on each specified day and for segment 1 on each day following the specified day.

For example, specify that a period event occurs on Mondays and Tuesdays with a From time of 17:00 and a To time of 08:00.
If Wrap around midnight is not selected:
  Monday Tuesday Wednesday
Midnight—08:00 (time segment 1) Yes Yes No
08:00—17:00 No No No
17:00—23:59 (time segment 2) Yes Yes No
If Wrap around midnight is selected:
  Monday Tuesday Wednesday
Midnight—08:00 (time segment 1) No Yes Yes
08:00—17:00 No No No
17:00—23:59 (time segment 2) Yes Yes No