Hello Everybody,

Is there a way to list the HISTORY of ther scheduled tasks in DB2.


Please help - I need to write a script to list all runs and return status of a scheduled job.


Thanks
DBFinder

platform/version ???

db2 v8.1.12

and

db2 v9.1.3

History for the last 5 days:

select h.TASKNAME00 as TaskName
,h.START00 as StartTime
,h.END00 as EndTime
,h.RETURNCODE00 as ReturnCode
from toolscat.MDTHISTORYTY00 h
where h.START00 > current timestamp - 5 days
;

Thanks a lot.

But on my system instead of
toolscat.MDTHISTORYTY00, systools.MDTHISTORYTY00

worked.
Thanks for help yvanroy
DBFinder