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

Teradata® Viewpoint User Guide

Product
Teradata Viewpoint
Teradata Workload Management
Release Number
17.10
Published
February 2022
Language
English (United States)
Last Update
2022-06-28
dita:mapPath
lks1628075605455.ditamap
dita:ditavalPath
tky1501004671670.ditaval
dita:id
B035-2206
lifecycle
previous
Product Category
Analytical Ecosystem

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