Scheduling E-mail Alerts

Greetings RoR:Talk,

I’m in the process of developing a web application for my company.
It’s a simple app developed to alleviate a portion of manual tasks for
our administration department. It’s core function will be to send an e-
mail alert to a user (or distribution list) in our administration
department when an item’s warranty date is near expiration.

Now, what I have developed so far is that a CUSTOMER has many ITEMS.
These ITEMS belong to a CUSTOMER. An ITEM has a warranty end date.
This structure is already in place and functioning correctly.

The next step I would like to take is to implement an automated
mailer. What I am unsure of is how to create a script of some sort
that will run daily, figure out which customer’s items are nearing
expiration, then e-mail our internal user. I’d say a good time frame
for when the e-mail is sent would be a week from expiration. That
could change, but a week would be good for now. This gives our staff
enough time to gather the required materials for the specific customer
and contact them about renewal.

Can all of this be handled with ActionMailer?

  • Mark

Watch these and I’m sure you will find a solution to your problem…