Shell script automation using cron which query's MySQL Tables Post: 303023673

Sponsored Content

Top Forums Shell Programming and Scripting Shell script automation using cron which query's MySQL Tables Post 303023673 by kkpand on Thursday 20th of September 2018 05:47:29 PM

09-20-2018

Registered User

okay, I have issues writing the script in the first place (like I said, new to scripting and crontab etc.. )

so far,

I made a wrapper script:

Code:

#!/bin/bash
## command for topdown report genration
for value in {164,174,59,78} ## more business_ids can be added in the future
do
   sh run_script.sh $value 
done

exit 0

this successfully runs and writes the output file in a different location
output164.out
output174.out
etc....

I tried to schedule it every 38 minute, for this I tried in crontab:

Code:

 
38 * * * * /complete/path/run_script.sh 2>&1 | tee /complete/output_files_path/* | mail -s "test_report" abc@xyz.com

note: like I mentioned earlier, the output files are many (4 for now), so I used * in the path...

as of now:
I end up with error

mail - blank
spool/mail/user ----- null, hope it's okay

tee: /complete_output_path/output/: ---- is a directory

I need:
All the files in the output directory to be send as attachments to email distribution lists
example: output1.out ----- email1
output2.out ----- email2

please let me know how to make it happen..

kkpand

View Public Profile for kkpand

Find all posts by kkpand

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Tables to query to find users for database from shell script

I am coding shell script. I need to connect to different databases like DB2, Oracle and Sybase. I would then need to query tables where it has all the groups, users for that database. I would also need who has what kind of permissions. EG: I know for DB2 some TABAUTH table needs to be...

2. Shell Programming and Scripting

Passing a variable from shell script to mysql query?

I heard this was possible but from my research I haven't been able to figure it out yet. Seems it should be simple enough. Basically from a high level view I'm trying to accomplish... . $X='grep foo blah.log' then 'mysql command SELECT foo FROM bar WHERE ' . $X or something like that. ...

3. Shell Programming and Scripting

Help with Shell Script automation

can someone look into this one please... I am struck at this point. I do not know what logic to be followed here. I can go ahead with my work only, if this step is done. Please Help. I have a process X in a shell script. Once the process X is done, it generates a log file. Process X is basically...

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

5. Shell Programming and Scripting

Help with Truststore automation shell script

Please close this thread. I have raise this question in appropriate thread. Thanks

6. Shell Programming and Scripting

Using a shell script variable in a mysql query using 'LIKE'

Hello. I am writing a simple script that reads a text file and removes records from a mysql database. The items in the text file are of the format: firstname.middle.lastXXX, where XXX is a 3 digit number. The table has an email field that will match the firstname.middle.last. So, I thought I...

7. Web Development

mysql query for multiple columns from multiple tables in a DB

Say I have two tables like below.. status HId sName dName StartTime EndTime 1 E E 9:10 10:10 2 E F 9:15 10:15 3 G H 9:17 10:00 logic Id devName capacity free Line 1 E 123 34 1 2 E 345 ...

8. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

9. UNIX for Beginners Questions & Answers

Using bash script : How to Import data from a dsv file into multiple tables in mysql

HI I have a dsv file that looks like: <<BOF>> record_number|id_number|first name|last name|msisdn|network|points|card number|gender 312|9101011234011|Test Junior|Smith|071 123 4321|MTN|73|1241551413214444|M 313|9012023213011|Bob|Smith|27743334321|Vodacom|3|1231233232323244|M...

LEARN ABOUT REDHAT

crond

CRON(8) 						      System Manager's Manual							   CRON(8)

NAME

       cron - daemon to execute scheduled commands (Vixie Cron)

SYNOPSIS

       cron

DESCRIPTION

       Cron should be started from /etc/rc or /etc/rc.local.  It will return immediately, so you don't need to start it with '&'.

       Cron searches /var/spool/cron for crontab files which are named after accounts in /etc/passwd; crontabs found are loaded into memory.  Cron
       also searches for /etc/crontab and the files in the /etc/cron.d/ directory, which are in a different format (see  crontab(5)).	Cron  then
       wakes up every minute, examining all stored crontabs, checking each command to see if it should be run in the current minute.  When execut-
       ing commands, any output is mailed to the owner of the crontab (or to the user named in the MAILTO environment variable in the crontab,	if
       such exists).

       Additionally,  cron checks each minute to see if its spool directory's modtime (or the modtime on /etc/crontab) has changed, and if it has,
       cron will then examine the modtime on all crontabs and reload those which have changed.	Thus cron need not be restarted whenever a crontab
       file is modified.  Note that the Crontab(1) command updates the modtime of the spool directory whenever it changes a crontab.

SEE ALSO

       crontab(1), crontab(5)

AUTHOR

       Paul Vixie <paul@vix.com>

4th Berkeley Distribution					 20 December 1993							   CRON(8)