I wish I discovered this earlier and AWS had built this earlier too.
I had a similar use-case at work but Event Bridge Scheduler was not available at that moment, only cron scheduling was available.
so I decided to build my own date based scheduler ( open sourced it recently)
Nice Article Sandro