Hi, You can refer to https://docs.databricks.com/sql/user/alerts/index.html and also for configuring alert access control you can check on https://docs.databricks.com/security/auth-authz/access-control/alert-acl.html.
Please let us know if this helps, also please tag @Debayan with your next response which will notify me, Thank you!
