01 March 2017

Export the jobs from Cloud Control

In case you need to backup your jobs from Cloud Control, you can use emcli for that. This will give you a quick way to backup or export the job for use elsewhere.

You can setup a script like:

EXPJOB=/home/oracle/export_jobs.sh
echo repdir=/backup/jobs > $EXPJOB

$OMSHOME/bin/emcli login -username=sysman -password=PassWord01

# One command to create the job
$OMSHOME/bin/emcli export_jobs -preview | awk '{ print "./emcli 
export_jobs -export_file=$repdir/" $1 ".zip -name=\x27" $1 "\x27" }' | sort >> $EXPJOB

#make it executable
chmod 740 $EXPJOB


# run the export
$EXPJOB


The EXPJOB that you create, will look like:

export repdir=/backup/jobs
./emcli export_jobs -export_file=$repdir/MYJOB01.zip -name='MYJOB01'
./emcli export_jobs -export_file=$repdir/MYJOB02.zip -name='MYJOB02'
./emcli export_jobs -export_file=$repdir/MYJOB03.zip -name='MYJOB03'
./emcli export_jobs -export_file=$repdir/MYJOB04.zip -name='MYJOB04'

If you run it, (from $OMSHOME/bin), it wil generate a seperate zip file for every job.
The zip file contains a single xml file for that job.

If you decide to import it, it will become available in the Job Library.

The import is easily done on the zip file, like:

 ./emcli import_jobs -file=$repdir/MYJOB01.zip

Hope this helps.

3 comments:

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. I am glad you take pride in what you write. This makes you stand way out from many other writers that push poorly written content.
    erp solutions for small business 

    ReplyDelete
  3. This is really a nice and informative, containing all information and also has a great impact on the new technology. Check it out here: Career advancement blog

    ReplyDelete