====== 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>