Job flow 13 · task:coupon-booking-maintenance (every minute) Diagram

Repeatable job coupon-booking-maintenance, every minute; attempts 3.
Idle selections: discount_selections still ACTIVE whose expiresAt passed (35 minutes after the last selection call, 24 hours at most) → EXPIRED.
Unattached slots: coupon_redemptions BOOKED with no subscription (reserved by a selection that never reached checkout) and bookingExpiresAt passed → RELEASED, coupons.bookingCount − 1, under the coupon row lock.
Checkout slots due: BOOKED rows attached to a signup subscription whose nextExpiryCheckAt passed → nextExpiryCheckAt moved 5 minutes ahead (so only one worker takes it) and task:coupon-booking-expire queued (flow 14).
Unfinished follow-ups: invoices with settlementApplied true and settlementFollowUpAt empty whose next check time passed → claimed for 5 minutes and task:payment-settlement-follow-up queued (flow 18). This is how a lost or failed follow-up (emails, next renewal job) is retried.