Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1588 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
I have created an Event in MySQL to run daily overnight and clean the data (Max
tharshulas
over 8 years ago
I have created an Event in MySQL to run daily overnight and clean the data (Max 2000 rows per day) from one of the tables. However I'm not able to handle the event failure to report/ send an email as MySQL event doesn't support sending emails.
The workaround I thought was to create a Poller (Event type process) in Appian to run daily overnight and call a stored procedure (it runs query in MySQL and do the necessary clean up in the table) and return the response back to Appian. So Appian can take necessary action depend on the response. Eg: Monitoring/ Send email alert.
any suggestions for both the approaches? which option would be ideal for my requirement?
OriginalPostID-211747
OriginalPostID-211747
Discussion posts and replies are publicly visible
Parents
0
Lakshmi Meyyappan
over 8 years ago
If your requirement is specifically to send an e-mail, then I believe your second approach would work well. As long as the data cleanup is still running in SQL (which it would be, via the stored procedure), then Appian can handle the rest of that without losing efficiency.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Lakshmi Meyyappan
over 8 years ago
If your requirement is specifically to send an e-mail, then I believe your second approach would work well. As long as the data cleanup is still running in SQL (which it would be, via the stored procedure), then Appian can handle the rest of that without losing efficiency.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data