sql submitted on timer
sql submitted on timer
(OP)
I need to run a SQL script unattended on a time/date basis.
For example, I need a select script to run every hour to extract a set of records into a delimited text file. What is the best way to accomplish this? Im working with Oracle Pl/Sql but have VB available if necessary. However, I want to use the most efficient method possible because the script will be running against a fairly large database.
Any advice, assistance in creating a text file with sql and running it unattended would be appreciated
bob
For example, I need a select script to run every hour to extract a set of records into a delimited text file. What is the best way to accomplish this? Im working with Oracle Pl/Sql but have VB available if necessary. However, I want to use the most efficient method possible because the script will be running against a fairly large database.
Any advice, assistance in creating a text file with sql and running it unattended would be appreciated
bob
RE: sql submitted on timer
schedule a sql script to start your PL/SQL.
RE: sql submitted on timer
thanks for the reply
RE: sql submitted on timer
to schedule the running of a stored procedure. The
stored procedure in turn could perform the select
into a cursor object, open up a file for writing,
then loop through the cursor and write out to your
file.
RE: sql submitted on timer
IT would be a great help if I could find some details on it.
thanks for the reply