If you want to perform the delete operation from your application by checking rules & integrity of the data, then you can create a job scheduler in your application and set appropriate time to run it.
There are many ways of creating job schedulers in C#, you can try Quartz.Net or
you can try the article below:
C# Scheduler[
^]