5.4 Digizuite Maintenance

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.

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)

See attached script