Search code examples
sqloracle-databaseplsqldatabase-administration

Task Automation on Toad for Oracle

I need to run more than 100 lines SQL queries 'execute as script' at 4 am, how can schedule it on oracle toad .

Solution

  • 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.