instantOLAP Online documentation 2.6.1 - Cron patterns

Cron patterns

cron-pattern := [ [ [ [ <month-pattern> ' '] <day-pattern> ' '] <day-of-week-pattern> ' '] <hour-pattern> ' '] <minute-pattern>

month-pattern := '*' | { (1..12) { , (1..12) }

day-pattern := '*' | { (1..31) { , (1..31) }

day-of-week-pattern := '*' | { (1..7) { , (1..7) }

hour-pattern := '*' | { (0..23) { , (0..23) }

minute-pattern := '*' | { (0..59) { , (0..59) }

Cron-Patterns are used in various elements of instantOLAP, e.g. for triggering synchronizing dimensions or the automatic sending of Mails. Cron-Patterns contain a single pattern for each part of the time: One for the month, one for the day, one for the day-of week, one for the hour and one for the minute. Each part can be "*" (stays for each month, each day and so on) or a comma-separated list of months, days, weekdays, hours or minutes (represented as numbers).

The cron-pattern matches if each part matches the corresponding part of the time (same month, same day etc.) or the corresponding part of the pattern is "*".

*

Every minute

* 0

Every hour (00:00, 01:00, ..., 23:00)

* 0 0

Every day at midnight

* 1 0

Every day at one a clock

Using the Web-Frontend
Using the Workbench
Using the Query-Editor
Using the Config-Editor
Concepts
Query properties
Chart properties
Configuration properties
Expressions
Formats
Date formats
Number formats
Cron patterns
Colors
SQL-Expressions