Book a vehicle service appointment and follow its reminders, 24 hours and 2 hours before the visit. A customer never receives the same reminder twice: if the service crashes in the middle of a send, the reminder is reclaimed when its lease expires and finished without being sent again.
UNIQUE (appointment, revision, type) on the reminder table.FOR UPDATE SKIP LOCKED, leased until processing_until, every write fenced by a claim token.notification_delivery before the provider is called; a retry finds it and sends nothing.No log lines yet. Book an appointment and the create and send lines show up here.
| # | Customer | Appointment | Reminders |
|---|
No appointments yet. Book one on the left.