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

    Note

    macOS and GNU/Linux has some limitations.

  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.

Shared tasks

When you create a task inside a Shared project, it becomes a shared task.

Shared tasks are visible to all users who have access to the Project. This helps teams coordinate and manage scheduled operations centrally.

Note

Only users with the Admin or Developer roles can access and execute scheduled tasks.

Download shared task results

Since shared tasks are executed on the server, the produced files are stored there as well.

To download results:

  1. Open the Task Manager panel
  2. Right-click the task in the execution list
  3. Choose View produced files

You'll see a window with the files. Select the ones you want, then click Download.

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.