spMFDeleteHistory¶
Signature¶
EXEC dbo.spMFDeleteHistory
@DeleteBeforeDate = '2000-01-01',
@BatchSize = NULL,
@Debug = 0;
- Returns
1 = Success
-1 = Error
- Parameters
- @DeleteBeforeDate
earliest date for retention of logs
- @BatchSize
Number of rows to delete per batch (default: 2000)
Purpose¶
The purpose of this procedure is to delete all records in MFlog,MFUpdateHistory,MFAuditHistory till the given date Additional Info —————
This procedure is built into an agent to run it on a schedule
Examples¶
EXEC spMFDeleteHistory @DeleteBeforeDate = '2023-11-01';
Run with Default Batch Size (2000 records)
EXEC spMFDeleteHistory @DeleteBeforeDate = '2023-11-01', @BatchSize = 5000;
Run with Custom Batch Size (5000 records per batch)
EXEC spMFDeleteHistory @DeleteBeforeDate = '2023-11-01', @BatchSize = NULL;
Run with Explicit NULL (Defaults to 2000)
EXEC spMFDeleteHistory @DeleteBeforeDate = '2023-11-01', @BatchSize = 5000, @Debug = 1;
Run with debug messages showing (use for agent messages also)
Changelog¶
Date |
Author |
Description |
2025-01-05 |
JPE |
|
2020-09-12 |
LC |
Add documentation |
2016-11-10 |
LC |
Add ProcessBatch and ProcessBatchDetail to delete |