Daily 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 :  this procedure will automatically delete history records from the logging tables that is older than the specified date.

  • spMFUpdateAllncludedInAppTables: this procedure will perform a daily update of all the class tables.