8.5  Automated tasks/jobs

Automated tasks lets you automate your database management job by 

scheduling the activities according to your requirement. They can be really useful 

for performing regular maintenance tasks such as backup, space monitoring, 

error checking, and maintenance, etc. 

MySQL reckons on operating system functionality for scheduling. On Windows 

platforms, MySQL uses the 

Task Scheduler

 services to schedule jobs. On Linux 

platforms, it uses 

cron 

to schedule jobs. Few scheduling tools are available in 

market that can be used for scheduling:

SQLyog Job Agent (SJA)

SJA is MySQL data synchronization and migration tool.

PhpJobScheduler

PhpJobScheduler is a tool to automate tasks by scheduling PHP scripts to 

run at set intervals.

DB2 UDB offers an administrative interface called 

Task Center 

to automate and 

schedule tasks. The Task Center can be used to execute tasks, either 

immediately or according to a schedule, and to notify people about the status of 

completed tasks. It provides the ultimate flexibility for centralized scheduling and 

server side execution.

With the help of Task Center you can:

Schedule the task

Specify success and failure conditions

Specify success and failure actions

Specify notification details

Specify conditional coding using task actions.

The Task Center is tightly coupled with Control Center, so it can be invoked either 

directly by calling 

db2tm

 or from the 

Control Center Tools  > Task Center

menu. Tasks can be created, saved, and reopened using a dialog or wizard 

within the Control Center. Figure 8 6 shows creation of tasks using Task Center.

248 

MySQL to DB2 UDB Conversion Guide