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

Sponsored Content

Top Forums Shell Programming and Scripting Shell script automation using cron which query's MySQL Tables Post 303023678 by Neo on Thursday 20th of September 2018 10:12:41 PM

09-20-2018

Administrator

First of all, your crontab entry does not schedule every 38 minutes:

Code:

38 * * * * /your/crontab/script.sh

That crontab entry executes at 38 minutes after the hour, every hour.

There are many examples of how to write a crontab entry in the man pages.

For example on linux:

https://www.unix.com/man-page/linux/5/crontab/

Quote:

EXAMPLE CRON FILE

Code:

# use /bin/bash to run commands, instead of the default /bin/sh
       SHELL=/bin/bash
       # mail any output to `paul', no matter whose crontab this is
       MAILTO=paul
       #
       # run five minutes after midnight, every day
       5 0 * * *       $HOME/bin/daily.job >> $HOME/tmp/out 2>&1
       # run at 2:15pm on the first of every month -- output mailed to paul
       15 14 1 * *     $HOME/bin/monthly
       # run at 10 pm on weekdays, annoy Joe
       0 22 * * 1-5    mail -s "It's 10pm" joe%Joe,%%Where are your kids?%
       23 0-23/2 * * * echo "run 23 minutes after midn, 2am, 4am ..., everyday"
       5 4 * * sun     echo "run at 5 after 4 every sunday"
       # Run on every second Saturday of the month
       0 4 8-14 * *    test $(date +%u) -eq 6 && echo "2nd Saturday"

Maybe you can review the examples and repost your idea for the correct crontab entry for us to review?

I am not the "kind of guy" to post solutions for people, as I prefer to lead people to learn to think and solve problems for themselves.

Quote:

SOAPBOX

If we just "give you the solution" then we are not teaching you to solve problems on your own; we are doing your work for you. We are here to teach and lead people to solutions, and to help them development themselves as unix/linux systems admins, developers, problem solvers and coders, not to do your work.

/SOAPBOX

Your reply describes a crontab entry that is different than your crontab entry.

Neo

View Public Profile for Neo

Visit Neo's homepage!

Find all posts by Neo

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 BSD

cron

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

NAME

       cron - clock daemon

SYNOPSIS

       /usr/sbin/cron

DESCRIPTION

       Cron  executes commands at specified dates and times according to the instructions in the files /etc/crontab and /etc/crontab.local.  None,
       either one, or both of these files may be present.  Since cron never exits, it should only be executed once.  This is best done by  running
       cron from the initialization process through the file /etc/rc; see init(8).

       The  crontab files consist of lines of seven fields each.  The fields are separated by spaces or tabs.  The first five are integer patterns
       to specify:

       o minute (0-59)

       o hour (0-23)

       o day of the month (1-31)

       o month of the year (1-12)

       o day of the week (1-7 with 1 = Monday)

       Each of these patterns may contain:

       o a number in the range above

       o two numbers separated by a minus meaning a range inclusive

       o a list of numbers separated by commas meaning any of the numbers

       o an asterisk meaning all legal values

       The sixth field is a user name: the command will be run with that user's uid and permissions.  The seventh field consists of all  the  text
       on  a  line  following  the sixth field, including spaces and tabs; this text is treated as a command which is executed by the Shell at the
       specified times.  A percent character (``%'') in this field is translated to a new-line character.

       Both crontab files are checked by cron every minute, on the minute.

FILES

       /etc/crontab
       /etc/crontab.local

7th Edition							 October 23, 1996							   CRON(8)