Sunday, 29 July 2012

Crontab Details


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

1 comment:

  1. Hi Mahesh,
    I 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

    ReplyDelete