Automatic FuzzyDB learning
To use the automation of FuzzyDB learning feature with a given batch class, perform the following procedure.
-
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 * * ?
If you upgrade Transact, the value configured in the fuzzydb.learndb.cronjob.expression property is used.
This feature performs the same function as when you click the Learn DB button. It creates Lucene indexes at regular intervals, eliminating the need to click Learn DB each time a change is made to the database.
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 |