How do I restore my view of Navigator, Projects, and the SQL Editor?
It is easy to accidentally close these views without a clear way to restore them. To restore them quickly, choose Window/Open Perspective/Other/DBeaver (default)
Automated Tasks
Automating SQL script to run on a schedule
- Right click on DBeaver project folder that contains the script to be automated and choose Set Active Project
- Create new task, choose SQL script, choose the sql script file to run, choose Connection to use
- Use the Scheduler to run the task on a given schedule in both DBeaver and Windows Task Scheduler
- If you don't see the file you created in one of the local schemas right away, right-click on the Connection used and choose Refresh