Email Notification after Event Execution

[Ashish1123]

Hi,

I have created an event which inserts data into table after every 2 minutes. I want Email Notification informing successful execution / Failure of event so that we can take corrective actions.

Attaching Table Definition and Event Definition for reference.

CREATE TABLE "test" (
"test_id" mediumint(9) NOT NULL AUTO_INCREMENT,
"test_date" datetime(6) NOT NULL,
PRIMARY KEY ("test_id")
)

CREATE EVENT AUTOINSERTNOTIFICATIO
ON SCHEDULE EVERY 2 MIN
ON COMPLETION PRESERVE
DO
INSERT INTO A90OPSP.TEST(test_id) values (NOW());