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
1573 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
0
PhilB
Certified Lead Developer
over 8 years ago
As you've mentioned, you could you move the data clean to a stored procedure, have appian call it from a process that runs on a timer, make the stored procedure return the results of the data clean and finally get appian to send the email with those results in.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
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
0
sikhivahans
over 8 years ago
Added to the suggestions made above, I would like to suggest to implement the processing in terms of batches, that is, few records at a time rather than all at once and also focus on the practices that needs to be taken care of while designing a batch process.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel