Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655

    Unanswered: LISTing TASK HISTORY

    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

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    platform/version ???
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  3. #3
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    db2 v8.1.12

    and

    db2 v9.1.3

  4. #4
    Join Date
    Jun 2002
    Posts
    15
    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
    ;

  5. #5
    Join Date
    Sep 2008
    Location
    Toronto,Canada
    Posts
    655
    Thanks a lot.

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

    worked.
    Thanks for help yvanroy
    DBFinder

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •