I need to run more than 100 lines SQL queries ‘execute as script’ at 4 am, how can schedule it on oracle toad .
Advertisement
Answer
In Toad, under Utilities > Task Scheduler, you can set up a task to launch SQLPlus at a specified time. In the parameters section of the task you can specify your connection information to the database and call the SQL script.