Real-time notification at exact datetime for Datetime field on Frappe Cloud

Hello All,

I am working on a Lead follow-up reminder use case and need guidance for implementing exact-time notifications based on a Datetime field on Frappe Cloud.

Use Case

  • Doctype: Lead

  • Custom Field: custom_next_followup_date (Field Type: Datetime)

Scenario:

  • User sets follow-up datetime (e.g. tomorrow at 12:00 PM)

  • Lead Owner should receive a system notification exactly at 12:00 PM

Issue

  • Standard Notification does not support exact-time triggers for Datetime fields.

  • Scheduled Server Scripts (Every Minute) run, but:

    • frappe.notify() does not work reliably in background jobs

    • System notification at exact datetime is not consistent on Frappe Cloud

  • Scheduler is enabled and workers are running.

Expected Outcome

  • A reliable, Frappe-recommended approach to:

    • Trigger system notification at the exact datetime stored in a Datetime field

    • On Frappe Cloud, without external cron or custom infrastructure

Request

Could someone please advise:

  • The best practice approach for this requirement?

  • Whether Frappe supports real-time Datetime-based notifications, or

  • If this requires a different design pattern (background jobs, reminders, etc.)

Environment

  • Platform: Frappe Cloud

  • ERPNext / Frappe Framework (latest stable)

  • Scheduler: Enabled

Thank you in advance for your guidance.