Show pageOld revisionsBacklinksODT exportBack to top This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong. ====== DB2 Automatic Task Scheduler ====== **List all jobs :** <sxh bash> 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" </sxh> **List job status :** <sxh bash> 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" </sxh> **Disable job (set max_invocation to 0) :** <sxh bash> db2 "call admin_task_update('DAILY REPORTER_STATUS ARHIVING',NULL,NULL,0,NULL,NULL,NULL)" </sxh> db2_ats.txt Last modified: 2019/10/18 20:04by 127.0.0.1