Skip to content

Task scheduler

Note

This feature is available in Enterprise, Ultimate and Team editions only.

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

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.

    Important

    When scheduling a task for the first time on macOS 10.15 or later, macOS will ask for permission. Click Yes to allow DBeaver to modify system cron settings.

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

View schedule details

You can view and manage scheduled tasks using your systemā€™s built-in scheduler.

Info

Tasks are scheduled using:

Windows

To open Windows Task Scheduler, right-click a task in the task view and select Scheduler ā†’ Open scheduler settings.

DBeaver stores all scheduled tasks in a folder named DBeaver.

macOS or Linux

To view the cron entries used for task scheduling, right-click a task and select Scheduler ā†’ Open scheduler settings.

You can also use the terminal:

crontab -l

Warning

While you can edit the crontab using crontab -e, we strongly recommend not doing so manually.

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

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

Limitations

Unix limitations

macOS and GNU/Linux, which work on cron have some limitations:

  • no start date option
  • no start time for minutely tasks
  • seconds are ignored even if you set them
  • most cron implementations only allow minute-level granularity

If you set a task to run 42 minutes past the hour, it'll run at 1:42 PM, 2:42 PM, etc. You can't configure it to run at 1:42:15 PM or only on certain dates.

Warning

Task start time is not guaranteed. The scheduler will try to run the task at the specified time, but execution may be delayed.

Troubleshooting

See Troubleshooting task scheduler issues for help with scheduled tasks.