Shell Programming and Scripting

Hi there, simple one hopefully....

I have a crontab entry that uses a .sh file. The .sh file essentially runs some mysql, writes the results to a text file and then emails it to specified emails.

Currently this works, but will email even if there are no results returned in the query. Is there a way to amend the .sh to take into considersation no results and therefore not sent the email?

Many thanks

Yes, you can amend the script to verify the text file where results are written after calling the SQL. If the text file is empty you can skip sending the email and simply exit.

Thanks for the reply Kirshmaths, ok will take a look at doing that and maybe verify on here what I have found before I try it! cheers

---------- Post updated at 10:31 AM ---------- Previous update was at 10:18 AM ----------
....

---------- Post updated at 11:08 AM ---------- Previous update was at 10:31 AM ----------

Ok, so would this work? Sorry, I am new to this:

Code:

 
mysql -Database -e "QUERY HERE" > /var/cron/result/result.txt
$FILE=/var/cron/result/result.txt
if [[ -s $FILE]]; then
cat /var/cron/result/result.txt | mail -s "Report" email@email.com
else 
:

Made a few corrections:

1. While setting a variable do not use $ (line 1).
2. Space is important in the test expression to be evaluated. Note that I have inserted a space between $FILE and ]]

Code:

FILE=/var/cron/result/result.txt
mysql -Database -e "QUERY HERE" > $FILE
if [[ -s $FILE ]]; then
cat /var/cron/result/result.txt | mail -s "Report" email@email.com
else 
:

excellent, that worked. spot on, thanks.