Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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
nameScript_RebuildDamIndexes.sql

...