DB2 Automatic Task Scheduler

List all jobs :

db2 "select varchar(name,30) name,BEGIN_TIME,END_TIME,MAX_INVOCATIONS,varchar(SCHEDULE,20) SCHEDULE,varchar(PROCEDURE_NAME,40) PROCEDURE_NAME from systools.ADMIN_TASK_LIST with ur"

List job status :

db2 "select varchar(NAME,60) JOB , BEGIN_TIME, END_TIME, timestampdiff(1,end_time-begin_time) elapsed, invocation, STATUS, SQLCODE from SYSTOOLS.ADMIN_TASK_STATUS order by job,invocation with ur"

Disable job (set max_invocation to 0) :

db2 "call admin_task_update('DAILY REPORTER_STATUS ARHIVING',NULL,NULL,0,NULL,NULL,NULL)"