DB2 10.5 for Linux, UNIX, and Windows

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.

Before you begin

The ADMIN_TASK_LIST administrative view is created the first time you call the ADMIN_TASK_ADD procedure. You must set up the administrative task scheduler and add a task before you can successfully query this view.
You must have SELECT or CONTROL privilege on the ADMIN_TASK_LIST administrative view.

Restrictions

When you query the ADMIN_TASK_LIST view, it returns only the tasks that were created by your session authorization ID. If you have SYSADM, SYSCTRL, SYSMAINT, or DBADM authority, all tasks are returned.

Procedure

Connect to the database.
Issue a query against the ADMIN_TASK_LIST administrative view. For example:
```
SELECT * from SYSTOOLS.ADMIN_TASK_LIST
```

Results

This administrative view retrieves the arguments that were used to create the tasks. It also lists the authorization ID of the task creator and the time that the task was last updated.

What to do next

To list the status of the execution of each task, use the ADMIN_TASK_STATUS administrative view.