Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Plus scripts vs DBMS_JOB
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