Home » SQL & PL/SQL » SQL & PL/SQL » Automatically run pl/sql or Sql*Plus script
icon8.gif  Automatically run pl/sql or Sql*Plus script [message #211795] Tue, 02 January 2007 06:04 Go to next message
Messages: 27
Registered: December 2006
Junior Member
I have a pl/sql and sql*plus script. I am passing 3 parameters (branch code and dates) to these scripts. The SQL*plus script produces a csv file. These scripts are to be run on a friday evening automatically. No user intervention to run the scripts. How do I get this done.


Re: Automatically run pl/sql or Sql*Plus script [message #211796 is a reply to message #211795] Tue, 02 January 2007 06:07 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Scheduling can be achieved using the DBMS_JOB (or DBMS_SCHEDULER on 10g) package.
Previous Topic: How to call a function(returning a number) inside an oracle package from vb.net ?
Next Topic: Query Returning Null Values
Goto Forum:

Current Time: Thu Oct 27 06:29:22 CDT 2016

Total time taken to generate the page: 0.16593 seconds