seeing this one and being like "ah using ETL principles to make sure your application isn't completely fucked"
anyway you have no idea how bad big companies data warehouses can be :)
ah yes i totally love how the front-end application at my last job let people just change policy numbers in place with no way for me to know that happened except that my audit controls are now failing because the policy count no longer matches to the source and target
0 */4 * * * /home/dba/backfill.pl
if this ever misses running more than once in a row we will be in immediate SOX, GDPR and ASBJ violation and we're all going to double-jail
oh god if you're at a company large enough to have to comply with sox controls you should NOT be using cron for ANYTHING

