By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 969 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

Email Notification after Event Execution

P: 1
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());
Sep 6 '16 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.