Hello All,
As per my bussiness requirement we need to write code to get all Record and process each record one by one and delete/update data in multiple table in SQL DB ,So what will be best for me to write SQL procedure and call in one SQL Job , or create one background service in asp core and write all code to fetch all record and process them one by one . Both Sql Job and Background service will run every 10 minutes .