login community faq

Hi,

Can I make a cron job for a specific query in MySql and send the results as an email (or email attachment)?

asked Jun 11 '12 at 05:31

xpanta's gravatar image

xpanta
6014


Hi,

You would need to make a script in a programming language such as Python, Perl, or PHP, that would process these results and send them via an email. You can then add this script as a cronjob.

To send the results of the cronjob via email, you just need to include the following line at the top of your crontab: MAILTO=email@example.org

answered Jun 11 '12 at 05:52

todork's gravatar image

todork
10964

Thanks, I can do that.

(Jun 11 '12 at 06:08) xpanta xpanta's gravatar image
Your answer
If you have an answer to the above question, then use the form below. Otherwise, use the appropriate 'add new comment' button above to post your feedback.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Tags:

×116

Asked: Jun 11 '12 at 05:31

Seen: 440 times

Last updated: Jun 11 '12 at 06:08

Plans & prices    Sign up    Why WebFaction?    Contact us    Affiliate program    Support    Legal    Jobs    Blog    Control panel login
Powered by OSQA
© Copyright 2003-2012 Swarma Limited - WebFaction is a service of Swarma Limited