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
    Location
    Wisconsin, USA
    Posts
    772

    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?

    TIA

    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/8.98.4.14, 9.1/9.1.5.3, 9.2/9.2.0.5/6
    IBM i, WebLogic on Windows, DBCS, Global installations.

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

    Re: Job to Purge Work Submitted Jobs display

    Tom,

    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.

    FWIW,

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

  3. #3
    Senior Member
    Join Date
    Nov 2000
    Posts
    148

    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

    R9861101..be 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).

    John

    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.