Expression Dependency - Multiple Time Windows
Overview
- Expressions allow Multiple Time Windows by using OR and/or AND functions to combine Expressions to make a true statement
Usage
- Utilizes 24-hour clock time
- When a job needs to run within a time window
- When a Self Service button should be made available
Example 1
- A job needs to run between 1:00 am AND 9:00 am
ToInt([[$TIMEhh]]) > 01 && ToInt([[$TIMEhh]]) < 09
Example 2
- A job needs to run between 1:00 am AND 9:00 am OR between 2:00 pm AND 5:00 pm
(ToInt([[$TIMEhh]]) > 01 && ToInt([[$TIMEhh]]) < 09)) || (ToInt([[$TIMEhh]]) > 14 && ToInt([[$TIMEhh]]) < 17)
Enterprise Manager
Details
Multiple Time Windows
Property Expressions allow Multiple Time Windows by using OR and/or AND functions to combine Expressions
- Utilizes 24-hour clock time
Examples:
Between 1:00 am and 9:00 am
TIME > 01 && TIME < 09
Between 1:00 am and 9:00 am or between 2:00 pm and 5:00 pm
(TIME > 01 && TIME < 09) || (TIME > 14 && TIME < 17)
Example:
Allows a Job to run between 02:00 am and 10:00 am OR 6:00 pm and 8:00 pm
(02 < ToInt([[$TIMEhhmm]]) && ToInt([[$TIMEhhmm]]) < 10) || (18 < ToInt([[$TIMEhhmm]]) && ToInt([[$TIMEhhmm]]) < 20)