This file contains ambiguous Unicode characters

This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.

Note

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

Table of contents

• Database Tasks view
  • Schedule a task
  • Update or cancel the schedule
• View schedule details
  • Windows
  • macOS or Linux
• Monitoring task execution
• Limitations
  • Unix limitations
• Troubleshooting

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.

Tasks are scheduled using:

• Windows Task Scheduler on Windows
• cron on macOS and GNU/Linux

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.

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

execution may be delayed.

Troubleshooting

See Troubleshooting task scheduler issues for help with scheduled tasks.