Is there a way to automatically execute a SQL script?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Is there a way to automatically execute a SQL script?

  1. #1
    Join Date
    Jun 2001
    Posts
    15

    Arrow

    I need to find a way to automatically make a script run against a certain instance on my dB. Is it possible? Is it possible to run scripts from the command line? SVRMGR? SQL Worksheet? SQLPlus?

    Any ideas are welcome!

  2. #2
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185
    Which platform?
    David Knight
    OCP DBA 8i, 9i, 10g

  3. #3
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Wink


    On Unix platform you can run a cron-job to automate a script.

    On NT you can use TASK scheduler to run a script if you like.

    - Magnus

  4. #4
    Join Date
    Jun 2001
    Posts
    15

    Platform

    Windows NT 4.0 SP6
    Oracle 8.0.5


    Also, I use the scheduler service all the time, but to execute an oracle script? I thought you had to be in SQL Worksheet or SQLPlus, etc. to do that?

  5. #5
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    you can schedule to run a batch file under WinAT or AT program on Windows NT. The contents of the batchfile will be like --

    C:\ORACLE\ORA81\BIN\SQLPLUSW.EXE userid/pass@hoststring @c:\scripts\Myscript.sql

    Also you can go to http://www.americansys.com/ and download a free version of EZSchedular for NT. It's pretty neat !!!

    - Rajeev
    Rajeev Suri

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