Regarding Batch Job to retrieve data from Client DB to our local DB
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Regarding Batch Job to retrieve data from Client DB to our local DB

  1. #1
    Join Date
    Sep 2008
    Posts
    4

    Regarding Batch Job to retrieve data from Client DB to our local DB

    Hi Folks,

    GoodDay, Previously I worked as a Oracle Developer and recently shifted into a BIG organisation as PL?SQL developer. Here my base work is with INTERFACES(Stored Procedure). That is retrieving data from client DB and need to put the data in our staging tables. For that i created 2 INTERFACES(stored procedures). One is for one time migration. No need to run on regular basis. The second one is to run regularly why because if any updations are done in client DB that should be replicate to our DB. For that we need to run a BATCH JOB regulary 24X7 basis.

    But i dont have any working knowledge on BATCH JOB creation and running. Please let me guide on this issue ASAP.

    Regards,
    Ramesh.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    You can develop procedures that may be executed in "your DB" at regual interval.
    You have plenty of options to execute the procedures:
    1. DBMS_SCHEDULER
    2. DBMS_JOB
    3. Shell Scripts.

  3. #3
    Join Date
    Sep 2008
    Posts
    4

    Post

    Thanks for your reply, Actually i have created 2 procedures.

    1. One time migration of data from client Db to our source. It will run only once.

    2. Will run once in 24 hrs to reflect the updations, which are made in client DB to our source DB.

    Previously i have no working knowledge on BATCH JOB creation and runing. Any advise on this is very helpful for me.

    Thanking you in Advance,
    Ramesh.

  4. #4
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Quote Originally Posted by Rammi
    ... i have no working knowledge on BATCH JOB creation and runing.
    Is it an Unix or Windows based environment?

    Either way, better to get familiar with scripting, shell scripting or DOS scripting depending on your environment being Unix or Windows based.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  5. #5
    Join Date
    Sep 2008
    Posts
    4

    Post Regarding BATCH JOB

    Our server OS is UNIX and Oracle product version is 9i.

    If possible please let me know both scripts. I mean to say for Windows and UNIX environment.

    Please reply ASAP..

    Thanks in Advance!
    Ramesh.

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    a script for what? its your job - use the tools available

    you choices are

    cron
    dbms_job

  7. #7
    Join Date
    Sep 2008
    Posts
    4
    Thanks buddy!

Posting Permissions

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


Click Here to Expand Forum to Full Width