Execute SQL Script

Automatically execute the SQL script on the remote or local MySQL server with a powerful task scheduler.

Create a task: Create a Execute SQL Script task.
Welcome Page: Welcome to the Task Wizard.
Step 1 - Task Name: Enter the name and the comment of the task.
Step 2 - Source MySQL Server: Enter the information of the source MySQL server.
Step 3 - Enter SQL Script: Enter the SQL script for running.
Step 4 - Task Scheduler: Choose the scheduler for running the task.
Step 5 - Task Information: View the task information and Finish to create a task.

Create a task
Double click the item or select the item and then click Create Task button to create a new task.

Welcome Page: Welcome to the Task Wizard! Please click Next to continue, or Cancel to exit.

Step 1 - Task Name: Enter the name and the comment of the task. Please do not enter an existent task name even if the original task had already been moved to the category Deleted Tasks. Please view the existent task in the category "All Avtive Tasks" or "Deleted Tasks".
Step 1

Step 2 - Source MySQL Server: Enter the information of the source MySQL server. The software will execute the SQL script on the source MySQL server. How to set up the options of Source MySQL Server?
Step 2

Step 3 - Enter SQL Script: Enter the SQL script. The software will execute the SQL script on the source MySQL server. How to set up the options for Entering the SQL Script?
Step 3

Step 4 - Task Scheduler: Choose the scheduler for running the task. The task will run on schedule with professional Task Scheduler ( Minutely, Daily, Weekly, Monthly, and with the Begin date and End date ). How to set up the options of Task Scheduler?
Step 4

Step 5 - Task Information: View the task information. Click Finish to create a task, or click Back if you want to review or change any settings.
Step 5

After clicking Finish, a new Execute SQL Script task will be created. It will automatically appears in the Task List.