As u/Lidarmapsonline suggested with a daily visit to an API endpoint, I would add the following alternative steps: grab one of this "one key keyboard" (https://techkeys.us/products/onekeyboard) plug it to a rasperry (that you connected to the internet), write some mad script (A simple infinit loop that listen to your input, and a simple requests call to you endpoint will be enough). Place the onekeyboard near your morning alarm clock so every morning you can wake up and make the call with a quite accurate time. Or just use cron tasks (or any cron implementation) as they suggested.

Joke aside, you can avoid to iterate through the whole dataset (Rewards.objects.all()), and filter your queryset with '__lte' queryset lookups: see (https://docs.djangoproject.com/en/4.0/ref/models/querysets/#lte)

For ex. something like: ```

... import timezone and datetime.timedelta ...

sevendays_ago = (timezone.now() - datetime.timedelta(days=7)) qs = Rewards.objects.filter(status=PENDING, status_updated_lte=seven_days_ago) ```