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?

Discussion posts and replies are publicly visible

Parents

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

Reply

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

Children

No Data