Advertisement

11.28.2007 at 11:28AM PST, ID: 22988600
[x]
Attachment Details

PLSQL/Job Scheduler execute SQL script file on system drive... possible?

Asked by CalDude in Oracle 9.x, PL / SQL

Tags: script, job, oracle, sql, file

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.Start Free Trial
[+][-]11.28.2007 at 12:00PM PST, ID: 20368200

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle 9.x, PL / SQL
Tags: script, job, oracle, sql, file
Sign Up Now!
Solution Provided By: jinesh_kamdar
Participating Experts: 2
Solution Grade: A
 
 
[+][-]11.28.2007 at 02:45PM PST, ID: 20369632

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628