Cron Job

[mehul_3]

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

[Yogeeraj_1 · Accepted solution]

hi,

Attached a typical format that i am used to.

hope this helps!
regards
yogeeraj

[Yogeeraj_1]

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

[Yogeeraj_1]

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

[Muthukumar_5]

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.

[Arturo Galbiati]

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

Art

[Himanshu_3]

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