...
SQL Indexes may be rebuild in a schedule. Digizuite provides a script that rebuilds tables that are impacted on daily use. The script is attached below.
It creates a SQL Agent that runs every Saturday at 17.30. This is configurable with the following snippet in the script:
| Code Block |
|---|
Exec sp_add_schedule @schedule_name=@ScheduleName, @enabled=1, @freq_type=8, -- weekly @freq_interval=64, -- saturdays @active_start_time=173000, -- 17:30:00 @freq_recurrence_factor = 1 -- Every Week (2 would be every 14 daya) |
See attached script
| View file | ||
|---|---|---|
|
...