Listing scheduled tasks

You can use the ADMIN_TASK_LIST function to list tasks that are scheduled for execution by the administrative task scheduler.

Procedure

To list scheduled tasks:

Connect to the Db2 subsystem with sufficient authorization to call the function ADMIN_TASK_LIST.

The function contacts the administrative task scheduler to update the Db2 task list in the table SYSIBM.ADMIN_TASKS, if necessary, and then reads the tasks from the Db2 task list. The parameters that were used to create the task are column values of the returned table. The table also includes the authorization ID of the task creator, in the CREATOR column, and the time that the task was created, in the LAST_MODIFIED column.