O'Reilly logo

MySQL Management and Administration with Navicat by Gokhan Ozar

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating and scheduling batch jobs

The execution of a series of tasks on a computer or server without manual intervention is known as batch processing, and it is something that most DBAs do daily if not all the time. These tasks are called jobs , which are set up so that they run in the background unattended, with all the input data preselected through scripts or command-line parameters.

Navicat provides a similar functionality allowing you to create batch jobs and set schedules, which can be executed at defined intervals or at a specific date and time, or both.

Batch jobs can be created for query, report printing, backup, data transfer, data synchronization, and data import and export. You can define a list of actions to be executed within a single ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required