Note: This functionality is available only in Enterprise-Edition.
DBeaver can schedule task execution for regular executions.
In version 6.x DBeaver supports only native Windows Task Scheduler. You can configure scheduler (CRON) manually on other OSes by calling
dbeaver-cli command line tool (see below).
Scheduling tasks from the Tasks view
You can open the tasks view from the main toolbar:
or from the main menu
Select a task that you want to schedule in the tasks view and open the context menu:
Scheduler configuration dialog will be opened. You can configure task frequency, recurrence period and start time there:
Then click on a
Schedule button. If everything is configured correctly you will see the confirmation dialog:
If anything goes wrong you will see an error message dialog. Error details can be viewed in the Error Log view.
You can change scheduler settings at any moment by choosing
Edit scheduled task command from the context menu. You can also cancel scheduling by clicking on
See schedule details and logs in the Windows Task Scheduler
You can see and change scheduled task details in the Windows Task Scheduler. Click on the
Open scheduler settings command in the task view context menu:
All DBeaver tasks are located in a folder
Monitoring for task execution
You can look through the task execution logs in the right side of the tasks view. By double clicking on a task run item you can see the full log with all details/errors/warnings:
DBeaver keeps the task run logs in the workspace directory, subfolder
Running tasks from the command line
The task scheduler uses the DBeaver command line interface to perform task execution. Command line parameter
-runTask TASK_ID launches saved task execution (immediately).
TASK_ID has form
@projectName:taskName. You can omit project name part if you have only one project in your workspace.
dbeaver-cli executable to run tasks.
Draw your attention that if you use
dbeaver executable (by any reason) you will need to add command line parameter
-nosplash to avoid splash screen appearance.
Configuring CRON scheduler