Skip to content

Task scheduler

Team Edition lets you automate routine tasks - like exporting data or running SQL scripts - by scheduling them to run at specific times.

Team Edition specialty

In Team Edition, tasks are executed on the server using the built-in Quartz scheduler. These tasks are stored in the Resource Manager container at /opt/resource-manager/workspace/{shared-projects|user-projects}/{project}/.dbeaver/tasks.json.

Database Tasks view

Use the Database Tasks view to schedule and manage your tasks.

To open the view:

  • navigate to Database -> Tasks -> Database Tasks
  • or go to Window -> Database Tasks

  • or click the Show View (Database Tasks) icon () in the main toolbar

    Note

    The toolbar is customizable. For further information, refer to Toolbar Customization article.

Schedule a task

To schedule a task:

  1. In the Database Tasks view, right-click the task you want to schedule

  2. Select Scheduler -> Schedule task

    • or select the task you want to schedule and click the Schedule task icon () in the Database Tasks toolbar.

  3. You'll see the scheduler configuration dialog. Here, you can set:

    • task frequency (hourly, daily, weekly, etc.)
    • recurrence pattern
    • start time
    • team name (Learn more)

  4. To save the schedule click Schedule button

    • if successful, you'll see a confirmation dialog
    • if something goes wrong, you'll see an error dialog. Open the Error Log view to get more info about what went wrong.

Task execution team

Note

Only the Administrator role can select the team that will run the task.

When you schedule a task, you choose which team provides the credentials for execution.

The scheduler uses that team’s shared credentials for the connection used in the task, so the task runs with the same permissions that team has on that connection.

Important

The team must have access to that connection. If the connection isn't shared with that team, the task won't be able to use the required credentials.

Update or cancel the schedule

To update or cancel the schedule:

  1. Right-click the task
  2. Select Scheduler -> Edit scheduled task to update, or Remove schedule to cancel

Monitoring task execution

You can view task execution logs on the right side of the tasks view.

Double-click a task run entry to see the full log, including detailed output, errors, and warnings.

Info

Team Edition stores task run logs in the workspace directory, under .metadata/task-stats.

Limitations

In Team Edition, shared tasks have certain limitations for data import and export. A scheduled task will not run if the export or import is set to a local file. To use shared tasks, Cloud Storage must be the target or source for all export and import tasks.

For exports, data needs to be saved in Cloud Storage. Similarly, for imports, the data must come from Cloud Storage.

Tip

You can export and import data directly between databases without needing Cloud Storage.

Troubleshooting

See Troubleshooting task scheduler issues for help with scheduled tasks.