AWS: What can I use to run periodic tasks on RDS?

Question

In specific RDS column as a date, I keep the information when user's trials end.

I'm going to check everyday these dates in database and when less the few days lefts to the end of trial, I want send an email message (with SES).

How can I run a periodic tasks in AWS to check database? I know that I can use:

• Lambda
• EC2 (or Elastic Beanstalk)

Is there any other solution which I've missed?

Answer 1

You can also use AWS Batch for this. This suits better if the job is heavy and takes more time to complete.

Answer 2

How long does it take to run your check? If it takes less than 300 sec and is well within the limits of Lambda (AWS Lambda Limits), then schedule tasks with Lambda: Schedule Expressions Using Rate or Cron

Otherwise, the best option is to use: AWS Data Pipeline. Very easy to schedule and run your custom script periodically. It charges at least one hour of instance.