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
1587 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
PhilB
A Score Level 1
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
Reply
0
PhilB
A Score Level 1
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
Children
No Data