There is any tool to schedule a SQL query and then receive the results every day?<p>I need to receive an email every morning telling me if my crawlers did run fine last night. I can do this with a simple SQL query.<p>I am willing to build this tool (in Node.js) if this tool does not exists just yet.<p>* No SaaS, please. I'm looking for a self-hosted option. I do not want to give a read-only password of my database for anybody.
Why not use cron?<p><pre><code> mysql the_database << "SELECT ...." | mail -s "Daily report" your@email
</code></pre>
You can insert some formatter in between if you want. If you'd rather send emails from a proper account and not local mailer, you can use ssmtp and configure a smarthost. (<a href="http://www.cyberciti.biz/tips/linux-use-gmail-as-a-smarthost.html" rel="nofollow">http://www.cyberciti.biz/tips/linux-use-gmail-as-a-smarthost...</a>)