00 18 * * 0 /db/bin/stats_009_bdp01.sh >/ora_bdp01/df/log/stats_009_bdp01.log$$ 2>&1
00 18 * * 0 /db/bin/stats_078_btp01.sh >/ora_btp01/df/log/stats_078_btp01.log$$ 2>&1
00 18 * * 0 /db/bin/stats_020_bcp01.sh >/ora_bcp01/df/log/stats_020_bcp01.log$$ 2>&1
00 17 * * 0 /db/bin/stats_002_bkp01.sh >/ora_bkp01/df/log/stats_002_bkp01.log$$ 2>&1
00 17 * * 0 /db/bin/stats_014_brp01.sh >/ora_brp01/df/log/stats_014_brp01.log$$ 2>&1
00 16 * * 0 /db/bin/stats_062_bgp01.sh >/ora_bgp01/df/log/stats_062_bgp01.log$$ 2>&1
00 16 * * 0 /db/bin/stats_065_bxp01.sh >/ora_bxp01/df/log/stats_065_bxp01.log$$ 2>&1
*/5 * * * * /home/user/test.pl
# .---------------- minute (0 - 59)
# | .------------- hour (0 - 23)
# | | .---------- day of month (1 - 31)
# | | | .------- month (1 - 12) OR jan,feb,mar,apr ...
# | | | | .----- day of week (0 - 6) (Sunday=0 or 7) OR sun,mon,tue,wed,thu,fri,sat
# | | | | |
# * * * * * command to be executed
I want a job to start every day at 22:00.
* 22 *** ss.sh ( script will run everyday at 10 PM
I want a job to start once a week at 18:00.
* 18**0 ss.sh (Script will run 6 PM every sunday)
I want a job to only run at 19:00 on 2/14/2011.
*19 14 2 * ss.sh (Script will run at 7 PM date 14 and Month Feb)
I want a job to run the 1st of each month.
* 19 1 1-12 * ss.sh (script will run at 7PM 1st day of every month).
$crontab -e for edit
$crontab -l for list
Hi Mahesh,
ReplyDeleteI want to take consistent rman backup before doing 10gR2 upgrade to 11g. Do I have to shutdown, bring it mount state and take level1 backup since my database is 1.5TB Appreciate your help