PLSQL/Job Scheduler execute SQL script file on system drive... possible?
Posted on 2007-11-28
I have a .SQL text file with basic SQL commands in it that I need executed by oracle. I know there are tons of better ways to do this, but for now I just want oracle to execute the script. In the past, I would have a job scheduler launch a bat file that would call SQLPlus passing the SQL file to launch, along with the instance, username & password. How can I do this within the oracle job scheduler? Thanks.