recurring resque with cron example

cron_payment_update.rb

require 'redis'
require 'mysql2'

# assuming redis is running on the default port.
# if not, example: redis = Redis.new(:host => "10.0.1.1", :port => 6380)
redis = Redis.new

# Make sure queue exists, if not create it. When clearing a queue with the resque web interface, resque removes the queue, so here we just check to make sure it exists.
if redis.sismember('resque:queues', 'update_payment') == false
  redis.sadd('resque:queues', 'update_payment')
end

# Mysql DB information
client = Mysql2::Client.new(:host => "localhost", :username => "root", :database => 'your_project_development')

# query the db for all payment records
results = client.query("SELECT `payments`.* FROM `payments` ORDER BY id asc")

# create a job in the update_payment queue that will update each payment, pass each payment id
results.each do |row|
  redis.rpush('resque:queue:update_payment', "{\"class\":\"UpdatePayment\",\"args\":[#{row['id']}]}")
end

crontab

# m h  dom mon dow   command
0 0 * * * /usr/bin/ruby /path/to/your/file/cron_payment_update.rb

update_payment.rb

class UpdatePayment
  @queue = :update_payment

  def self.perform(payment_id)
    payment = Payment.find_by_id(payment_id)
    if payment
      # update payment logic goes here
    end
  end
end

http://aaronvb.com/blog/2011/5/12/recurring-resque-and-redis-with-cron/