biweekly schedule through cron

anksagr · #1 (**permalink**) 01-09-08, 16:46

Hi All,

This is the first time I am posting on this forum.

I want to schedule my DB2 reorgchk every other sunday through cron.

I did the following:

PHP Code:


		
			
# Bi-Weekly REORGCHK for db2 databases.

00 06 1-7,15-21 * * [ "$\(date +\%a\)" == "Sun" ] && /usr/local/db2/online_reorgchk.sh 2>&1

for some reason it runs just the first sunday that falls between 1-7 and does not run on the sunday that falls between 15-21.

Am I doing it right? Is there a better way to schedule a script every other sunday?

Thanks for the help

Anks

stolze · #2 (**permalink**) 01-10-08, 09:39

Quote:

Originally Posted by anksagr

Code:

# Bi-Weekly REORGCHK for db2 databases.
00 06 1-7,15-21 * * ...

for some reason it runs just the first sunday that falls between 1-7 and does not run on the sunday that falls between 15-21.

This would run your command every day from the 1st thru 7th and 15th thru 21st of each month (at 6:00). So your statement saying that it just rons on the first Sunday is not true. The following should do the restriction for the Sunday as well:

Code:

00 06 1-7,15-21 * 7 ...

The crontab specifications for the weeks are fine. If it doesn't work, maybe your cron doesn't support this format? If so, you could split this up into multiple crontab entries.

Bob4480 · #3 (**permalink**) 02-23-08, 00:58

anksagr

Try this, it worked on my server.

Code:

00 06 1-7,15-21 * * test `date +\%a` = Sun && /usr/local/db2/online_reorgchk

Good Luck

xtremenw · #4 (**permalink**) 03-07-08, 23:51

Quote:

Originally Posted by Bob4480

anksagr

Try this, it worked on my server.

Code:

00 06 1-7,15-21 * * test `date +\%a` = Sun && /usr/local/db2/online_reorgchk

Good Luck

Code:

00 06 1-7,15-21 * Sun /usr/local/db2/online_reorgch

Will do the same thing since the last * was for Day of Week. `man 5 crontab` gives the exact details...

Prevents the system from starting a shell command to check that it is sunday and continue if it is...

stolze · #5 (**permalink**) 03-08-08, 05:48

Quote:

Originally Posted by Bob4480

anksagr

Try this, it worked on my server.

Code:

00 06 1-7,15-21 * * test `date +\%a` = Sun && /usr/local/db2/online_reorgchk

Good Luck

Why so complicated? Just use the infrastructure that cron provides.