DB2 Version 10.1 for Linux, UNIX, and Windows

Using the administrative task scheduler

The administrative task scheduler
The administrative task scheduler enables DB2® database servers to automate the execution of tasks. It also provides a programmable SQL interface, which allows you to build applications that can take advantage of the administrative task scheduler.
Setting up the administrative task scheduler
The administrative task scheduler is disabled by default. You can use the procedures and views to define and modify tasks but the scheduler will not execute the tasks. To set up the administrative task scheduler, configure the DB2_ATS_ENABLE registry variable and create the SYSTOOLSPACE table space.
Adding a task to the administrative task scheduler
You can use the ADMIN_TASK_ADD procedure to define new scheduled tasks. The parameters that you use when you call the procedure define the schedule and the work for each task.
Listing tasks in the administrative task scheduler
You can use the ADMIN_TASK_LIST administrative view to list tasks that are scheduled for execution by the administrative task scheduler.
Listing the status of tasks in the administration task scheduler
You can use the ADMIN_TASK_STATUS administrative view to list the status of task execution in the administrative task scheduler.
Updating a task in the administrative task scheduler
You can use the ADMIN_TASK_UPDATE procedure to update a scheduled task.
Removing a task from the administrative task scheduler
You can remove a scheduled task or task status records from the task list using the ADMIN_TASK_REMOVE procedure.

Parent topic: DB2 administration tools