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






footer




 

 

 

 

 Home | About Us | Network | Services | Support | FAQ | Control Panel | Order Online | Sitemap | Contact

san diego web hosting

 

Our partners: PHP: Hypertext Preprocessor Cheap Web Hosting JSP Web Hosting Ontario Web Hosting  Jsp Web Hosting

Cheapest Web Hosting Java Hosting Cheapest Hosting

Visionwebhosting.net Business web hosting division of Vision Web Hosting Inc.. All rights reserved