Daily and monthly routines for agentsΒΆ
There are a number of procedures that should be considered for inclusion in daily or monthly maintenance routines in SQL Agent Jobs.
spMFDeleteHistory: automatically delete history records from the logging tables that are older than the specified date.
spMFUpdateAllncludedInAppTables: perform a daily update of all the class tables.