Cron scheduling
When using the advanced schedule option for DataTranslator, you can use this Quartz cron format: Seconds, Minutes, Hours, Day of Month, Month, Day of Week, Year.
This table shows the values and special characters that you can use for each field:
| Field | Value | Special characters |
|---|---|---|
| Seconds | 0–59 | *, - / |
| Minutes | 0–59 | *, - / |
| Hours | 0–23 | *, - / |
| Day of Month | 1–31 | *, - ? / L W |
| Month | 1–12 or JAN–DEC | *, - / |
| Day of Week | 1–7 or SAT–SUN | *, - ? / L # |
| Year | 1970–2099 or * | *, - / |
This table shows the description and example for each of the special characters:
| Special character | Description | Example |
|---|---|---|
| * | Any value | |
| ? | No specific value
Used for day-of-month or day-of-week |
|
| - | Range | MON-FRI |
| / | Increment | 0/5 in minutes means every 5 minutes |
| , | List | MON,WED,FR |
| L | Last | Last day of month, last Friday |
| W | Nearest weekday | 15W |
| # | Nth weekday of the month | 2#1 = 1st Monday |
This table shows sample cron expressions and their description:
| Expression | Description |
|---|---|
| 0 0 12 * * ? | Every day at 12:00 PM |
| 0 15 10 ? * * | Every day at 10:15 AM |
| 0 0/5 14 * * ? | Every 5 minutes from 2:00 PM to 2:59 PM |
| 0 0 8 ? * MON-FRI | Weekdays at 8:00 AM |
| 0 0 0 L * ? | Last day of every month at midnight |
| 0 0 10 ? * 6#3 | 3rd Friday of every month at 10:00 AM |
The default value in the Enter cron expression field in the Edit Schedule dialog box is 0 0 3 1/1 * ? *, which indicates that the schedule runs every day at 3:00 AM, every month, and every year.