Skip to content
By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Send an email notification once the MySQL stored proc executed

0

We are loading the data using a procedure in the MySQL rds instance. The stored procedure would be called from an ETL job. We want email notifications to be sent when the procedure completes or fails.

Topics
Database
Tags
Aurora MySQLMySQL
Language
English
asked 2 years ago558 views
1 Answer
0

There is no direct support of such feature in MySQL RDS. Amazon RDS events supports only these categories https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/USER_Events.Messages.html

There are multiple programatic way you can achieve such notification e.g. Write status of stored proc in another table and let another client app keep polling for success/failure status and send email notification.

AWS
answered 2 years ago
  • rePost-User-6143205
    2 years ago

    Thanks for sharing the info...what would be the other ways to achieve it?

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Relevant content