Implement periodic job to clean up test data

[Ahmed-Ghanam]

Description

We need to implement a periodic job to clean up test data from the Notifications database to maintain a clean and efficient environment.

Additional Information

This cleanup job is crucial for sustaining system performance by preventing the accumulation of test data. It must be designed to operate automatically without disrupting system operations and should include safeguards to prevent the accidental deletion of non-test data.

Tasks

• Define the criteria for test data

  • Identify what constitutes test data within our system.
  • Determine the age threshold for data to be considered for cleanup.

• Implement the cleanup job

  • Develop a script or service that will run periodically.
  • Ensure the job can identify and delete test data based on the defined criteria.

• Schedule the job

  • Utilize a scheduling tool (e.g., cron, Azure Functions) to execute the job at regular intervals.
  • Ensure the job runs without impacting system performance.

• Testing and validation

  • Validate that the job does not delete any non-test data.

• Documentation

  • Document the implementation details and configuration instructions for the job.

Acceptance Criteria

• The periodic job runs successfully at the scheduled intervals.
• Test data older than the specified threshold is deleted.
• No non-test data is affected by the cleanup job.
• Documentation is complete and clear.