Automatic FuzzyDB learning
To use the automation of FuzzyDB learning feature with a given batch class, follow the procedure described below.
-
Navigate to and click Add.
The Add Connection section appears.
-
Set the value in the FuzzyDB Learn Frequency (cron) field.
The default value for new configuration entries is: 0 0 0 * * ? .
During an upgrade from earlier versions, the installer reads the fuzzydb.learndb.cronjob.expression property and migrates its value to the database. After the upgrade, the schedule can be configured using the FuzzyDB Learn Frequency (cron) field in Connection Manager.
Setting a value in the FuzzyDB Learn Frequency (cron) field schedules automatic database learning. The system runs the same operation as the Learn DB button at the specified intervals and creates Lucene indexes automatically, so manual execution is not required each time the database changes.
Configure CronJob
Automatic FuzzyDB learning is performed at a regular interval, defined by a CronJob expression.
For the CronJob expressions, view the following table.
| Field | Mandatory | Allowed values | Allowed special characters |
|---|---|---|---|
|
Seconds |
YES |
0-59 |
, - * / |
|
Minutes |
YES |
0-59 |
, - * / |
|
Hours |
YES |
0-23 |
, - * / |
|
Day of the Month |
YES |
1-31 |
, - * ? / L W |
|
Month |
YES |
1-12 or JAN-DEC |
, - * / |
|
Day of week |
YES |
1-7 or SUN-SAT |
, - * ? / L # |
|
Year |
NO |
empty, 1970-2099 |
, - * / |
For the CronJob examples, view the following table.
| Expression | Meaning |
|---|---|
|
0 0 0 * * ? |
Trigger at 12am every day |
|
0 0 12 * * ? |
Trigger at 12pm (noon) every day |
|
0 15 10 ? * * |
Trigger at 10:15am every day |
|
0 15 10 * * ? |
Trigger at 10:15am every day |
|
0 15 10 * * ? * |
Trigger at 10:15am every day |
|
0 15 10 * * ? 2005 |
Trigger at 10:15am every day during the year 2005 |
|
0 * 14 * * ? |
Trigger every minute starting at 2pm and ending at 2:59pm, every day |
|
0 0/5 14 * * ? |
Trigger every 5 minutes starting at 2pm and ending at 2:55pm, every day |
|
0 0/5 14,18 * * ? |
Trigger every 5 minutes starting at 2pm and ending at 2:55pm, AND trigger every 5 minutes starting at 6pm and ending at 6:55pm, every day |
|
0 0-5 14 * * ? |
Trigger every minute starting at 2pm and ending at 2:05pm, every day |
|
0 10,44 14 ? 3 WED |
Trigger at 2:10pm and at 2:44pm every Wednesday in the month of March |
|
0 15 10 ? * MON-FRI |
Trigger at 10:15am every Monday, Tuesday, Wednesday, Thursday, and Friday |
|
0 15 10 15 * ? |
Trigger at 10:15am on the 15th day of every month |
|
0 15 10 L * ? |
Trigger at 10:15am on the last day of every month |
|
0 15 10 ? * 6L |
Trigger at 10:15am on the last Friday of every month |
|
0 15 10 ? * 6L |
Trigger at 10:15am on the last Friday of every month |
|
0 15 10 ? * 6L 2002-2005 |
Trigger at 10:15am on every last Friday of every month during the years 2002, 2003, 2004 and 2005 |
|
0 15 10 ? * 6#3 |
Trigger at 10:15am on the third Friday of every month |
|
0 0 12 1/5 * ? |
Trigger at 12pm (noon) every 5 days every month, starting on the first day of the month |
|
0 11 11 11 11 ? |
Trigger every November 11th at 11:11am |