scheduling sql loader
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: scheduling sql loader

Hybrid View

  1. #1
    Join Date
    Jan 2002
    Posts
    83

    scheduling sql loader

    hi all

    I recently updated a table in windows 2000 server and oracle 816, using sql loader and flat files. I would like to know how to schedule sql loader for loading purposes in the evenings. Please guide me on how to write a script or guide me to a web page .



    thnakx
    ICEMAN

  2. #2
    Join Date
    Dec 2000
    Location
    Virginia, USA
    Posts
    455
    If it was UNIX you could use crontab, but I think in Windows env there is a schedualar, that you can configure to execute a job.

  3. #3
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by irehman
    If it was UNIX you could use crontab, but I think in Windows env there is a schedualar, that you can configure to execute a job.
    Correct.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"

  4. #4
    Join Date
    Apr 2003
    Location
    Miami Beach, FL
    Posts
    3

    scheduling sql loader

    You will want to create a BAT program that executes your script. Then place the execution of this BAT file in the Schedules Task wizard under Programs...Accessories...System Tools...Scheduled task...

    You might be able to do this straight as a sqlloader.exe task but I have never tried.

    Hope this helps,
    Miller
    There is no "patch" for stupidity.

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