for crone

You can use whenever plugin for managing cron jobs. And there are
enough tutorials available on Internet about cron, it's a very simple
thing, you can read and understand.

Use script/runner to run ActiveRecord kind of queries, a google search
on it will help. Otherwise you can run mysql queries also if you wish
so.

PS: It's not crone but cron.