Duplicate prevention
PostgreSQL advisory locking elects one scheduler transaction at a time. Row locks and the(schedule_id, scheduled_for) constraint prevent a restart or overlapping tick from emitting the same occurrence twice.
Schedules define daylight-saving, misfire, jitter, concurrency, and no-runner behavior. A spring-forward wall time that does not exist is not silently shifted. Bounded backfill is explicit, and an existing occurrence is not re-emitted.