Working with Delete Maintenance
Step | Job | Properties |
|---|---|---|
none | none | column |
1 | Archive Check | |
2 | Graph Maintenance | Days to Keep Bulk Size |
3 | Result Maintenance | Days to Keep Bulk Size MinResultsPerUnitAndProgram |
4 | Event Maintenance | Days to Keep Bulk Size |
5 | Maintenance Log | Days to Keep Bulk Size |
6 | Program and Unit Maintenance | Days to Keep Bulk Size Delete Program by Last Used Date |
7 | History Maintenance | Days to Keep Bulk Size |
8 | Tools Maintenance | Days to Keep Bulk Size Delete Manual Tool |
Default Values
Days to Keep = 9999
Bulk Size = 5000
Delete Manual Tool = 0
Delete Program by Last Used Date = 0
MinResultsPerUnitAndProgram = 0
Editing and Scheduling Jobs
Run the database manager.
Go to the Job Scheduler for database type.
In the database Job Scheduler, configure the settings as per the specific job requirements.
Configuring Job Steps Properties
@Bulksize and @DaysToKeep: those properties define how long data should be stored and how large should be the chunks to be deleted. Each "delete operation" deletes data in batches, and each batch deletes a number of rows. The maximum number of rows that can be deleted, which is equal to @Bulksize. This operation is repeated until all data longer than @DaysToKeep are deleted.
@DeleteManualTool: this property selects if the manual tools are to be deleted or not.
@DeleteProgramByLastUsedDate: this property selects how programs are to be deleted when running the maintenance job for program and unit.
@MinResultsPerUnitAndProgram: this property determines whether there is a minimum required number of results to keep for each Unit and Program combination regardless of @DaysToKeep. Applies to SQL Server installations only.
In the Select a page box select Steps.
In the Job step list select the necessary step. Then, select Edit.
In the General tab/command field, set the needed properties value and select OK.
@DaysToKeep = 0, keeps data from the current day.
@DeleteProgramByLastUsedDate = 0, makes the job delete programs based on when the programs were created/uploaded to the controller.
@DeleteProgramByLastUsedDate = 1, makes the job delete programs based on when the programs were last used by the controller.
@MinResultsPerUnitAndProgram = 0. Runs the job without any restrictions of the minimum number of results to keep per Unit and Program combination.
@MinResultsPerUnitAndProgram > 0. Runs the job with respect to the number of minimum number of results to keep per Unit and Program combination.
