homehome previousprevious nextnext
 
Welcome to Navicat MySQL
Getting Started
Connection Settings
Database Object Management
Queries
Data Management Tools
Report Management Tools
Server Security Management
MySQL Maintenance Tasks
Options
Navicat Support Center
Knowledgebase (Online)
Visual Demo (Online)
Batch Job/Schedule

Navicat for MySQL allows you to create a batch job for setting schedule to execute at one or more regular intervals, beginning and ending at a specific date and time using Windows Task Scheduler. Batch job can be created for Query, Report printing, Backup, Data Transfer, Data Synchronization, Import and Export. You can define a list of actions to be performed within one batch job, either run it manually or at the specified time/periodically.

Just sample click to open an object pane for Schedule. A right-click displays the popup menu or using the object pane toolbar below, allowing you to create new, edit, open and delete the selected batch job/schedule.

Create Batch Job

To create a new batch job

  • Select anywhere on the object pane.
  • Click the New Batch Job from the object pane toolbar.
    or
  • Right-click and select New Batch Job from the popup menu.
  • Edit batch job properties on the appropriate tabs.

    • Hint: To create new batch job you can also right-click the Schedules node of the navigation pane and select the New Batch Job from the popup menu.

To create a new batch job with modification as one of the existing batch jobs

  • Select the batch job for modifying in the navigation pane/object pane.
  • Right-click and select the Design Batch Job from the popup menu.
    or
  • Click the Design Batch Job from the object pane toolbar.
  • Modify batch job properties on the appropriate tabs.
  • Click Save As.
Edit Batch Job

To edit the existing batch job

  • Select the batch job for editing in the navigation pane/object pane.
  • Right-click and select the Design Batch Job from the popup menu.
    or
  • Click the Design Batch Job from the object pane toolbar.
  • Edit batch job properties on the appropriate tabs.

To change the name of the batch job

  • Select the batch job for editing in the navigation pane/object pane.
  • Right-click and select the Rename from the popup menu.

Run Batch Job

To run a batch job

  • Create a new batch job/open the existing one.
  • Click Start.

Delete Batch Job

To delete a batch job

  • Select the batch job for deleting in the navigation pane/object pane.
  • Right-click and select the Delete Batch Job from the popup menu.
    or
  • Click the Delete Batch Job from the object pane toolbar.
  • Confirm deleting in the dialog window.

Set Schedule

To set schedule to the batch job

  • Create and save the batch job/open the existing one.
  • Select the batch job in the navigation pane/object pane.
  • Right-click and select the Set Task Schedule from the popup menu.
    or
  • Click the Set Task Schedule from the object pane toolbar.
  • Set your schedule using Windows Scheduler.

    • Hint: LogCmd.txt stores all the operations executed, indicating success or failure during the schedule.

Delete Schedule

To delete a schedule

  • Select the scheduled batch job in the navigation pane/object pane.
  • Right-click and select the Delete Task Schedule from the popup menu.
    or
  • Click the Delete Task Schedule from the object pane toolbar.
  • Confirm deleting in the dialog window.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 
Copyright 1999 - 2007. PremiumSoft TM CyberTech Ltd All rights reserved
MySQL TM is a trademark of MySQL AB in the United States and other countries.