mjhjmtu

#!/bin/bash
#--------------------------------------------------------------------------

daily="FILE_PATH/Daily"
weekly="/FILE_PATH/Weekly"
semianually="/FILE_PATH/SemiAnnually"

_endDate=$(date +"%m%d%Y")
_day=$(date +"%u")

if [ $_day -ge 1 ] || [ $_day -le 7 ]
then
 backNumDays="180"
 directory=$semianually
 _beginDate=$(date -d "183 days ago" +"%m%d%Y")
 report="$_beginDate-$_endDate"SemiAnnualReport".csv"
else
 :
fi

if [ $_day -ge 1 ] || [ $_day -le 7 ]
then
 backNumDays="7"
 directory=$weekly
 _beginDate=$(date -d "7 days ago" +"%m%d%Y")
 report="$_beginDate-$_endDate"WeeklyReport".csv"
else
 :
fi

if [ $_day -ge 1 ] || [ $_day -le 7 ]
then
 backNumDays="1"
 directory=$daily
 _beginDate=$(date -d "1 day ago" +"%m%d%Y")
 report="$_beginDate-$_endDate"DailyReport".csv"
fi


#_____sql query_______
exec_file_Report()
 

 status=`/SIDS/app/oracle/product/12.1.0.2/client/bin/sqlplus -S << +++
 $DB_CONNECT
 --
 SET head on
 SET feedback OFF
 SET pagesize 10000
 SET linesize 2000;
 SET colsep ,
 set trimspool on
 set trimout on
 set trims on
 set UNDERLINE OFF
 set verify off
 set echo off
 set term off

 spool "$directory/$report"

 SELECT * FROM TABLE_NAME WHERE rownum <= $backNumDays
 ;
 spool off
 exit
+++
`


exec_file_Report 

I can not figure out why a daily report is being generated. The cron is setup to run: Everyday for daily, Sunday for weekly and last day of month for semiannual. The reason all my ifs are using the same parameters it simply to test my code in the event multiple conditions occur such as Sunday also being the last day of the month.

Perhaps I’m missing something,
but I guess you want (this test version of) your script
to generate all three reports every time you run it. 
But the script just isn’t set up
to generate multiple reports in a single invocation. 
The general flow of what happens when you run the script is

if (condition that’s always true)
then
 backNumDays="180"
 directory="$semiannually"
 ︙
else
 :
fi

if (condition that’s always true)
then
 backNumDays="7"
 directory="$weekly"
 ︙
else
 :
fi

if (condition that’s always true)
then
 backNumDays="1"
 directory="$daily"
 ︙
fi


(Generate daily report)

You need to do something like

(define exec_file_Report function)

if (it’s the last day of the month)
then
 backNumDays="180"
 directory="$semiannually"
 ︙
 exec_file_Report
fi

if (it’s Sunday)
then
 backNumDays="7"
 directory="$weekly"
 ︙
 exec_file_Report
fi

backNumDays="1"
directory="$daily"
 ︙
exec_file_Report

This script can generate all three reports in a single invocation. 
For example, on February 10, February 17, February 24,
March 3, March 10, March 17 and March 24 (all of which are Sundays),
it will do the monthly report and the daily report. 
On February 28 it will do the semiannual report and the daily report. 
On Sunday March 31 it will do all three. 
So you only need to run the script every day;
you don’t need the three cron lines.

Now you’re saying that, on any of the above multiple-report days,
you want the daily report to be generated at 2 PM
and the other(s) at 11:59 PM. 
This is the sort of detail
that should have been included in the question
when I asked for clarification. 
To handle this, you must make the script either smarter or less smart. 
I recommend making it less smart. 
Change it, not to figure out for itself what report(s) to generate,
but to take an argument telling it which report to generate. 
Something like this:

(define exec_file_Report function)

case "$1" in
 (semiannual)
 backNumDays="180"
 directory="$semiannually"
 ︙
 exec_file_Report
 ;;

 (weekly)
 backNumDays="7"
 directory="$weekly"
 ︙
 exec_file_Report
 ;;

 (daily)
 backNumDays="1"
 directory="$daily"
 ︙
 exec_file_Report
 ;;
esac

And then keep the crontab entries you have now, but add the arguments:

0 14 * * * /path/to/your/script daily
59 23 * * 0 /path/to/your/script weekly
59 23 (last) * * /path/to/your/script semiannual

Ummm — how are you using cron to run a job on the last day of the month?

Warning: I have not tested the above.

Notes:

• There’s no reason to do else   :.


• There’s no reason to use an if to test a condition that’s always true
  to handle code that you want to execute every time.


• 
  exec is the name of a Unix system function and a shell command. 
  Using it as part of the name of a function is confusing.