Results 1 to 5 of 5

Thread: Job to Purge Work Submitted Jobs display

  1. #1
    Member Tom_Davidson's Avatar
    Join Date
    Nov 2000
    Wisconsin, USA

    Job to Purge Work Submitted Jobs display

    I know there is a job to purge jobs more than X days old. But for the life
    of me, I can no longer find it. does anyone know the Report name?


    Tom Davidson
    OW 7332 SP 11.3, AS/400 V4R5, CO on NT, TSE

    OW 7332 SP 11.3VER, NT 4.0 SP 5, TSE 4.0 SP 4, Metrframe 1.8, CO SQL 7.0

    Cleindori Consulting
    8.12/, 9.1/, 9.2/
    IBM i, WebLogic on Windows, DBCS, Global installations.

  2. #2
    Senior Member Larry_Jones's Avatar
    Join Date
    Nov 2000
    Spokane, WA, USA

    Re: Job to Purge Work Submitted Jobs display


    some time back I found an old object that was supposed to do this but it apparently had been written for an earlier release of OW and never updated (sorry can't remember the name anymore).

    I ended up writing a new one that deletes entries in F986110 that are older than a given number of days - it was pretty easy to write - just read and delete rows from F986110.


    Larry Jones
    OneWorld B733.1, SP 11.3
    HPUX 11, Oracle SE 8.1.6
    SandBox: OneWorld XE
    Larry Jones
    E1 9.2 - TR on Win 2016 R2. SQL Server 2016
    Wintel, BI Publisher

  3. #3
    Senior Member
    Join Date
    Nov 2000

    RE: Job to Purge Work Submitted Jobs display

    On B7331 it is on the GH9012 menu and the report name is R9861101.

    -----Original Message-

  4. #4

    RE: Job to Purge Work Submitted Jobs display sure to look at the data selection for R9861102 which the
    first one calls. There is some garbage in the versions for the R9861102
    which will prevent it from finding jobs (you will get no data selected).
    Once the data selection is fixed it runs fine (locally only).


    Xe, SP14.2, SQL7/Sp3, NT/SP6a

  5. #5

    Re: RE: Job to Purge Work Submitted Jobs display

    Thanks for the info - most helpful....
    This job will only run OK on Local then? - Because this would confirm what I am doing! - When run on the server it doesn't work....
    Cheers, Mike

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.