0

I'm not a DBA, so bear with me.

I've scheduled tasks through Toad's automation designer, but this uses Windows task scheduler. It's using Oracle 12c. All I'm doing is updating (creating/dropping) tables with the most recent data. Then I use an ODBC to report on that data in another application.

How can I ensure my scripts execute on time without running a local machine with scheduled tasks? Can this be done without additional software? Thanks in advance.

0

DBMS_SCHEDULER is your friend https://docs.oracle.com/database/121/ADMIN/scheduse.htm and https://oracle-base.com/articles/10g/scheduler-10g – Philᵀᴹ Oct 21 at 19:11

Also, I recommend you use SQL Developer instead. That software has a GUI interface for creating the scheduled jobs to run.

SQLDeveloper Connections pane showing the Scheduler tree branch

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.