topic Re: Cron Job in Operating System - HP-UX

Cron Job

mehul_3 — Thu, 11 Aug 2005 01:27:22 GMT

I would like to cron a job say /home/oracle/shutdown.sql after every two days.I am aware of the format but I am going to implement it on first time.

Pl. guide me in this regard.

Regards,
Mehul

Re: Cron Job

Yogeeraj_1 — Thu, 11 Aug 2005 01:29:38 GMT

hi,

Attached a typical format that i am used to.

hope this helps!
regards
yogeeraj

Re: Cron Job

Yogeeraj_1 — Thu, 11 Aug 2005 01:34:02 GMT

hi again,

sorry forgot the attachment.

note that i am here using root user to schedule the job using cron, you can alternatively use the Oracle User itself.

if you need any further hep, let us know.

regards
yogeeraj

Re: Cron Job

Yogeeraj_1 — Thu, 11 Aug 2005 01:41:38 GMT

hi,

if you need additional help on how to configure or give appropriate permissions for cron, please refer to the following url:
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=939316

or man crontab

regards
yogeeraj

Re: Cron Job

Muthukumar_5 — Thu, 11 Aug 2005 02:57:27 GMT

You can try as,

# Minue Hour monthday month weekday
30 12 * * * /home/oracle/shutdown.sql 1>/dev/null 2>&1

If /home/oracle/shutdown.sql is a shell script then put code in the begin as,

if [[ $((`date +'%m'`%2)) -ne 0 ]]
then
echo "No need to execute it
exit 0
fi

else put this in a script and execute /home/oracle/shutdown.sql from this script.

hth.

Re: Cron Job

Arturo Galbiati — Fri, 12 Aug 2005 03:24:55 GMT

You can type 'man crontab' to see usage and parameter.

Art

Re: Cron Job

Himanshu_3 — Fri, 12 Aug 2005 03:47:05 GMT

Mehul,

The below may help you as well

# 00 00 * * * /usr/local/scripts/cronscript
# | | | | | |
# | | | | | script to run
# | | | | +---------- month
# | | | +------------ day
# | | +-------------- day of the week 0-6, 0 = sunday, 1-5 = mon to fri
# | +----------------- hour of the day 00 to 23
# +-------------------- minute 00 to 59

Rgds,
Himanshu