Oct 21, 2016 08:10 PM|Nasser Malik|LINK
You can put your code in console and attach the exe to windows scheduler which can run it after some interval.
You can make a windows service which can call the database to do the job
You can use SQL server Schedule Job.
You can use
timer class to run your function on regular interval. Put this in global.asax application_start() to call a function on regular basis. But this is not a recommended approach as application pool can be reset at any time. And your code will not run if you
app idle for longer period.
Sharing some links which surely can help