nicq
nicq

Reputation: 2314

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

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:

Is there any other solution which I've missed?

Upvotes: 8

Views: 10197

Answers (3)

helloV
helloV

Reputation: 52433

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.

Upvotes: 2

Ashan
Ashan

Reputation: 19758

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

Upvotes: 4

Mahesh Gareja
Mahesh Gareja

Reputation: 1812

Go with lamda here

You can create a Lambda function and direct AWS Lambda to execute it on a regular schedule. You can specify a fixed rate (for example, execute a Lambda function every hour or 15 minutes), or you can specify a Cron expression.

Upvotes: 2

Related Questions