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 MINIX

mail

MAIL(1) 						      General Commands Manual							   MAIL(1)

NAME

       mail - send and receive electronic mail

SYNOPSIS

       mail [-dpqrv] [-f file] [user]

OPTIONS

       -d     Force use of the shell variable MAILER

       -f     Use file instead of /usr/spool/mail/user as mailbox

       -p     Print all mail and then exit

       -q     Quit program if SIGINT received

       -r     Reverse print order, i.e., print oldest first

       -v     Verbose mode

EXAMPLES

       mail ast 	   # Send a message to ast

       mail		   # Read your mail

DESCRIPTION

       Mail  is  an  extremely simple electronic mail program.	It can be used to send or receive email on a single MINIX system, in which case it
       functions as user agent and local delivery agent.  If the flag MAILER is defined in mail.c, it can also call a transport  agent	to  handle
       remote mail as well.  No such agent is supplied with MINIX.

       When  called  by  user  with no arguments, it examines the mailbox /usr/spool/mail/user, prints one message (depending on the -r flag), and
       waits for one of the following commands:

	 <newline> Go to the next message
	 -	   Print the previous message
	 !command  Fork off a shell and execute command
	 CTRL-D    Update the mailbox and quit (same as q)
	 d	   Delete the current message and go to the next one
	 q	   Update the mailbox and quit (same as CTRL-D)
	 p	   Print the current message again
	 s [file]  Save message in the named file
	 x	   Exit without updating the mailbox

       To send mail, the program is called with the name of the recipient as an
       argument.  The mail is sent, along with a postmark line containing the date.
       For local delivery, a file named after the recipient in the directory
       /usr/spool/mail must be writable.

       If the directory /usr/spool/mail does not exist then the mail is
       dumped on the console, so that system programs have a way to notify
       a user on a system that does not have a mail spool.

																	   MAIL(1)