...
Schedule | Description |
|---|---|
0 0 30 2 | will run at 2:30am each day |
0 0 30 2,14 | will run at 2:30am and 2:30pm each day |
0 0 30 2,8,14,20 | will run at 2:30am, 8:30am, 2:30pm and 8:30pm each day |
0 0 30 2 3 | will run at 2:30am each Tuesday |
0 0 30 2 * 1 | will run at 2:30am on the first of each month (do not use*) |
0 0 30 2 * 1 2 | will run at 2:30am on the first of February each year (do not use*) |
0 0 30 2 5 * 2 | will run at 2:30am on each Thursday of February each year (do not use*) |
0 0 30 2 4 1 2 | will run at 2:30am on each Wednesday and on the first of February each year |
0 0 15,45 | will run every half hour at quarter past and quarter to |
*It appears that using * for the day of week or day of month may cause issues (like the index continually being built).
Note that since building the indexes can be CPU intensive you should stagger the rebuilding so that you don't try and rebuild more than one index at a time.
...