SQL developer in an Oracle fix - best way to schedule a SqlPlus script to run?
Posted on 2014-02-07
I am not an Oracle/linux developer but am working on an Oracle/linux project for a remotely hosted database. I've succeeded in creating two sqlplus scripts (.sql) which create text output using spool, and can download these via sftp and import the results into SQL Server on my own planet.
The problem is, I need one script (main.sql) to run nightly and the other (today.sql) to run every 5 minutes.
What is the best way to approach this? Cron or DBMS_SCHEDULER? Obviously I will need examples--I haven't had to fool with a cron in 15 years and am only just getting the feel of Oracle.
Linux 2.6.32-279.9.1.el5.vs126.96.36.199.29.6.23.JRB.8.x86_64 x86_64
Oracle Database 11g Enterprise Edition Release 188.8.131.52.0 - 64bit Production
PL/SQL Release 184.108.40.206.0 - Production
CORE 220.127.116.11.0 Production
TNS for Linux: Version 18.104.22.168.0 - Production
NLSRTL Version 22.214.171.124.0 - Production