topic Re: Seeking crontab solution in Operating System - HP-UX

Seeking crontab solution

ROBIN METZLER — Fri, 02 Apr 2004 10:50:49 GMT

I need to schedule two shell scripts to run in the cron scheduler every two weeks on a sunday evening and every two weeks on a wednesday. I know that a can schedule the jobs for the first and fifteenth day of the month, however this is not what I need. The scripts need to run every 14 days to coincide with a payroll cycle. I may be overlooking the obvious solution, but I can't seem to find a workable answer.

Thanks in advance for any assistance.

Re: Seeking crontab solution

Nicolas Dumeige — Fri, 02 Apr 2004 10:56:37 GMT

Why not schedule the two scripts sunday and wednesday - day of the week column - and make the script check for the last run, for instance with a flag file or the last log.

Have you consider using the at command ?

Re: Seeking crontab solution

Todd McDaniel_1 — Fri, 02 Apr 2004 11:01:17 GMT

Sounds like a great candidate for a script to be run at boot as a startup script.

I believe cron would be too convoluted a way to do it, since it could be any Sunday and any Wednesday from month to month.

Just modify your scripts to check a 14 day interval then check the day of the week to be sure it is the correct day.

Or you can hardcode it to check the Julian date.

Re: Seeking crontab solution

Geoff Wild — Fri, 02 Apr 2004 11:02:09 GMT

Check out Clay's datehammer:

http://www.cmve.net/~merijn/#Contrib

Though the link seems to be down at the moment...

Rgds...Geoff

Re: Seeking crontab solution

G. Vrijhoeven — Fri, 02 Apr 2004 11:04:56 GMT

Hi,

Link to Clays script:

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

HTH,

Gideon

Re: Seeking crontab solution

A. Clay Stephenson — Fri, 02 Apr 2004 11:05:08 GMT

The key to doing what you want is to put some smarts inside your cron'ed script to determine if this is the payroll week. Your respective cron jobs should run every Wednesday and every Sunday.

The key to this is caljd.sh; with no arguments it will return the current Julian Day (number of days since 4712 BCE). You divide that by 7 to get the week and then a mod 2 will yield 1 or 0 to get you every other week.

In your cron'ed script or cron'ed wrapper script do this:

payroll_wk()
{
typeset -i10 WK=$((($(caljd.sh) + 1) / 7))
typeset -i10 WK2=$((${WK} % 2))
return ${WK2}
} # payroll_wk

typeset -i10 THIS_WK=$(payroll_wk)
if [[ ${THIS_WK} -eq 0 ]]
then
echo "Do it"
else
echo "Don't; exit"
fi

You may need to change the logic so that if 1 you do it and also note that $(caljd.sh) + 1 is used so that the new week starts on Sun. Becuase of this, your "Sunday" logic will probably be different from your "Wednesday" logic.

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

Re: Seeking crontab solution

Paula J Frazer-Campbell — Fri, 02 Apr 2004 11:05:13 GMT

Todd has it.

Set in cron an entry to run every day at the correct start time.
In the script check if day of week is Sun or Wed and also check from a flag file if it is 14 days since last run time.

at the end of script if it is run then touch a flag file.

Paula

Re: Seeking crontab solution

ROBIN METZLER — Fri, 02 Apr 2004 11:47:54 GMT

Thanks to everyone for your input. This has rejunvinated my creative juices to solve an apparently simple task.

Thanks for your time. I appreciate it.