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.vs188.8.131.52.29.6.23.JRB.8.x86_64 x86_64
Oracle Database 11g Enterprise Edition Release 184.108.40.206.0 - 64bit Production
PL/SQL Release 220.127.116.11.0 - Production
CORE 18.104.22.168.0 Production
TNS for Linux: Version 22.214.171.124.0 - Production
NLSRTL Version 126.96.36.199.0 - Production