Digizuite maintenance is optional, but can in some cases improve the experience.
Maintenance is about running cleaning tasks on a schedule.
Rebuilding SQL Indexes
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:
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)