Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus scripts vs DBMS_JOB

SQL*Plus scripts vs DBMS_JOB

From: B <sbo1999_at_hotmail.com>
Date: Sun, 22 Apr 2001 17:29:09 -0400
Message-ID: <u2IE6.1820$y54.244734@wagner.videotron.net>

As an Oracle dba team we have an increasing number of SQL*Plus scripts called by a NT scheduler to do jobs on different Unix db servers. It is somewhat practical, we can connect on any schema and especially spool results where we want in the format we want. Now we want to migrate that to Oracle jobs and use DBMS_JOB. It should be a better approach and most of the jobs wil be better handled. But for some others small jobs the script method is hard to beat.
Would anyone know of a rather simple way to still call SQL*Plus scripts from within a Job ?
Would any Oracle-supplied packages would offer these kind of calls ? It could make our lives easier !

Thanks in advance.
Serge Received on Sun Apr 22 2001 - 16:29:09 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US