View Poll Results: job scheduling in unix platform

Voters
0. You may not vote on this poll
  • how to add any script file through daily schedule.

    0 0%
  • how to run any oracle script,pls.give solution through example

    0 0%
Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Bhopal
    Posts
    1

    Unanswered: regarding jobscheduling in unix plat form

    dear friends ,

    On security measure , i want to perform the backup(fullexport)
    of database through jobscheduling for every day through backup
    script, for which i tried to add the same in uucp file under following
    path: /var/spool/cron/crontabs , but it is not working.
    please anybody know about jobscheduling then please suggest
    suitable solution ,and also suggest how to run any
    script of oracle through fixing the job shedule in unix platform.
    please give the solution with example.


    srinivas sastry
    O/o the AGMP(A/E)I,Bhopal.

  2. #2
    Join Date
    Mar 2002
    Location
    Ireland
    Posts
    181
    Hi,
    I'm not sure if I'm answering your question but this is how to setup a scheduled export using crontab:

    In the crontab file:

    0 5 * * * "/db/u05/oradata/EXPORT/DAILY/expDaily.sh" > /dev/null 2>&1

    And the expDaily.sh file could look like this:

    # construct a directory name, create it and a parfile and do export
    . /export/home/oracle/.profile
    dir=`date +"%d%m%Y"`
    mkdir /db/u05/oradata/EXPORT/DAILY/${dir}
    cd /db/u05/oradata/EXPORT/DAILY/${dir}
    echo full=y >expfull.par
    echo consistent=y >>expfull.par
    echo buffer=10485760 >>expfull.par
    echo direct=y >>expfull.par
    echo log=./expfull.log >>expfull.par
    echo file=./expfull.dmp >>expfull.par
    echo indexes=y >>expfull.par
    echo rows=y >>expfull.par
    exp / parfile=./expfull.par
    gzip -9 expfull.dmp

    -------------
    Hope this helps.

    Rgs,
    Breen.

  3. #3
    Join Date
    May 2003
    Location
    Dublin, Ireland
    Posts
    44
    To setup crontab file use:
    contab -e
    this will open crontab file for editing.

    To see your crontab file use:
    crontab -l

    Cheers,

    Jacek

    Originally posted by Breen
    Hi,
    I'm not sure if I'm answering your question but this is how to setup a scheduled export using crontab:

    In the crontab file:

    0 5 * * * "/db/u05/oradata/EXPORT/DAILY/expDaily.sh" > /dev/null 2>&1

    And the expDaily.sh file could look like this:

    # construct a directory name, create it and a parfile and do export
    . /export/home/oracle/.profile
    dir=`date +"%d%m%Y"`
    mkdir /db/u05/oradata/EXPORT/DAILY/${dir}
    cd /db/u05/oradata/EXPORT/DAILY/${dir}
    echo full=y >expfull.par
    echo consistent=y >>expfull.par
    echo buffer=10485760 >>expfull.par
    echo direct=y >>expfull.par
    echo log=./expfull.log >>expfull.par
    echo file=./expfull.dmp >>expfull.par
    echo indexes=y >>expfull.par
    echo rows=y >>expfull.par
    exp / parfile=./expfull.par
    gzip -9 expfull.dmp

    -------------
    Hope this helps.

    Rgs,
    Breen.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •