how to write a script to run last sunday in a month

[TDN]

Hi,

Need some help to schedule a script to run last sunday in a month.

Thanks in advance.


TDN

[Geoff Wild]

Check out this thread:

http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=707481

Rgds...Geoff

[TDN]

Hi,

Thanks Geoff.

I think i do the easy way.

In my script the `date +%d` must be less than 22.

I try this first.

Regards
TDN

[TDN]

Hi,

Thanks Geoff.

I think i do the easy way.

In my script the `date +%d` must be greater than 22.

I try this first.

Regards
TDN

[Rick Garland]

The last Sunday of a month will typically be between the 24th and the 30th. There will be a couple of exceptions in which the month has 31 days and the last Sunday of the month is the 31th.

There are date calculators abound. You can even find one in the forums here. Do a search for datecalc

[Muthukumar_5]

I hope we can not define it with cron time informations on crontab file settings.

But we have to include lines on executable script to check weather

1> The day is equal to 22 and month is feb and year divisble by 4 ( leaf year) and exit from that script execution.

2> Check month 31 days, leaf year and check weather it is less than 25 there.

3> Check month 31 days, leaf year and check weather it is less than 24 there.

Execution of there check will not take more than 2 secs there. So that,

execute the script on crontab on 22-31 and the executed script checks the day settings and do execution / exit without execution.

[Muthukumar_5]

On the executable script add the following lines after header (#!) as,

# 1> feb month
if [[ $(date +'%m') -eq 02 && $(($(date +'%Y')%4))) -eq 0 ]]
then
if [[ $(date +'%e') -eq 22 ]]
# Don't do this
exit
fi
fi

# 2> 31 days month and augest (08) month
if [[ $(($(date +'%m)%2) -eq 1 || $(date +'%m) -eq 08 ]]
then
if [[ && $(($(date +'%Y')%4))) -eq 0 ]]
then
if [[ $(date +'%e') -le 24 ]]
# Don't do this
exit
fi
else
if [[ $(date +'%e') -le 23 ]]
# Don't do this
exit
fi
fi
fi

# 3> 30 days month
if [[ $(($(date +'%m)%2) -eq 0 && $(($(date +'%Y')%4))) -eq 0 ]]
then
if [[ $(date +'%e') -le 23 ]]
# Don't do this
exit
fi
else
if [[ $(date +'%e') -eq 22 ]]
# Don't do this
exit
fi
fi
fi

Keep the sequence, and do exit after logging message in log file if you want there.

[John Poff]

Hi,

Clay Stephenson's date hammer script is probably the best way to go. If you are interested in hacking another method, you could try this trick:

cal | tail -2 | head -1 | awk '{print $1}'

which will give you the date of the last Sunday of the current month.

JP

[Geoff Wild]

#!/bin/sh
#***************************************************************
#
# Description : This script should be run in cron every sunday.
# It will execute the desired command on the last
# Sunday of the month
#*************************************************************
#*************************************************************
# GLOBAL VARIABLE DECLARATIONS
#*************************************************************
BASE=/usr/local/bin
MONTH=`date +%m`
YEAR=`date +%y`
DAY=`date +%d`
COMMAND=


#*************************************************************
# BEGIN FUNCTION SECTION
#*************************************************************

twenty_eight () {
if [ $YEAR = 04 ]
then
if [ DAY -gt 22 ]
then
$COMMAND
fi
else
if [ DAY -gt 21 ]
then
$COMMAND
fi
fi
}


thirty () {
if [ DAY -gt 23 ]
then
$COMMAND
fi
}


thirty_one () {
if [ DAY -gt 24 ]
then
$COMMAND
fi
}


case $MONTH in
01|03|05|07|08|10|12) thirty_one;;
04|06|09|11) thirty;;
02) twenty_eight;;
esac


Rgds...Geoff

[Muthukumar_5]

We can simply do this as,

# Check today's date equal to last sunday of current month
if [[ $(date +'%e') -ne $(cal | grep -v "^$" | awk '{ print $1 }' | tail -1) ]]
then

# exit
exit 1

fi

John. You are really great. I heard as " Think simple to do great" and found here. I wrote a big script lines but you showed your best here. Thanks for your guidance.

[RAC_1]

Why go through this all???

cal | cut -c1-2|grep -v "^$"|tail -1 will give the date of the last sunday.

Now you have the date, set the script.

Anil

[John Poff]

Muthukumar,

Thanks for the praise. I like to keep things simple. I'm too lazy to do all that hard thinking! :)

You can modify your code just slightly and get the last day of the month for any weekday. Just move the 'grep' after the 'awk', so that the blank lines are removed after the dates are printed. For example, to test for the last Friday of the month, this would work:

if [[ $(date +'%e') -ne $(cal | awk '{ print $6}' | grep -v "^$" | tail -1) ]]

Then you just adjust the variable in the awk print statement for the day of the week you want ($1 through $7 for Sunday through Saturday).

JP

[Geoff Wild]

Anil - wow - using cal - that's cool - that's worth 11 points in my book :)

Rgds...Geoff

[A. Clay Stephenson]

Here is one method. First create a cron entry to run your script every Sunday; theyt script itself will then decide whether or not to simply exit and do nothing or continue.

#!/usr/bin/sh

export PATH=${PATH}:/usr/local/bin

if [[ $(caljd.sh -M) -eq $(caljd.sh -n 7 -M) ]]
then
exit 0
else
echo "Last Sunday in month; do your thing"
fi

The idea is that that it looks at the current day's month and compare's it to that 7 days hence. If they differ, it's the last time that weekday occurs in the month.

By the way, caljd.sh -N will yield the occurence of a given weekday within the month.

Invoke as caljd.sh -u for full usage and examples.

[Sridhar Bhaskarla]

Hi,

I was stunned by that one liner but that's a great try. For ex.,

cal 08 04 |tail -2 |head -1 |awk '{print $1}'

is not giving me the last sunday ;-).

I believe the best approach is given by Clay. We use similar logic here where some of our maintenance windows are on 2nd Sunday!!. Add 7 to the current date and if the resulting date is of next month, then that's it. Run it every sunday.

#!/usr/bin/ksh
NOW=$(/usr/contrib/bin/perl -e "printf("%d\n",time())")
MON=$(date +%b)


(( NEXTMON_SECS = $NOW + ( 7 * 86400 ) ))


NEXTMON=$(echo "0d${NEXTMON_SECS}=Y" |adb |awk '{print $2}' )

if [[ "$MON" != "$NEXTMON" ]]
then
echo "OK!.. this is the last sunday."
#your_function
else
echo "More sundays to go"
exit 0
fi

-Sri

[Geoff Wild]

# cal 08 04
August 4
S M Tu W Th F S
1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28 29 30
31

# cal 08 04 | cut -c1-2|grep -v "^$"|tail -1
31

Looks like last Sunday to me...

Rgds...Geoff

[Geoff Wild]

Of course cal 08 04 is 1904... :)

# cal 08 2004 | cut -c1-2|grep -v "^$"|tail -1
29

Rgds...Geoff

[TDN]

Hi,

Thank you all of you.

I think I go for the solution to put the script in cron running every sunday and check out if the date is the last sunday inside the script.

I found a example on bigadmin.com

Once again, thanks guys.

Regards
TDN