Results 1 to 6 of 6

Thread: Periodic Maintenance - Clear Submitted Jobs

  1. #1

    Periodic Maintenance - Clear Submitted Jobs

    Maintenance Item - Clear Submitted Jobs


    Description - UBE's submitted leave a record in Work With Submitted jobs and a PDF (and UBE logs) in the PrintQueue directory on the enterprise server. One can manually clear the WSJ list (which *should* delete the PDF's/Logs from PrintQueue or you can run the R9861101 .

    Denver will tell you that this job needs to be run locally but I have made it work in the past from scheduler submitted to an enterprise server. On other systems, no such luck. This was in my notes and I may get it to be dependable some day:

    "You must have the target server in Logical Datasources in the Server Map for the environment (server?) in (on?) which the job (scheduler server?) is running"

    Regardless, the R9861101 is a useful method to clear WSJ and PrintQueue. Keep in mind that some versions of E1 (8.11) have a bug and PrintQueue does not get cleared on R9861101 run.


    Method - R9861101


    Frequency - Weekly


    Notes- Set to remove jobs older than x number of days, where x is a number negotiated between the business and the IT department. The IT department wants to minimize disk space usage and the business wants to maximize the amount of time a report can be retrieved. As the CNC person, this is kinda like throwing a steak into a group of dogs then stepping back and watching the fun- let them fight it out.


    Run Method - Scheduler if possible, otherwise locally on a fat client.


    Disclaimer - As with all postings please ask questions on the forum and do not contact me personally unless:

    1) you are my buddy and want to buy me a beer, 2) you wish to tell me "Happy Birthday" or 3) you wish to engage my services during December and your company is in Miami.


  2. #2
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,738

    Re: Periodic Maintenance - Clear Submitted Jobs

    Just a note

    Due to SOX, Regulatory and Company Imposed policies - many organizations
    Tweak the R9861101 (or the entire process to run the ube) in such a way that
    lists of reports are always omitted.

    Before starting too far down the process - you may want to work with your
    SOX and Financial folks - to validate that proper document control is well
    within the works of design.

    (db)

    On Thu, May 8, 2008 at 7:56 AM, brother_of_karamazov <jxs2151@mindspring.com>
    wrote:



    --
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  3. #3

    Re: Periodic Maintenance - Clear Submitted Jobs

    I've been running this manually every Monday from my fat client. Could you elaborate just a tad more on how one should be able to get this to work from the Scheduler? Would I need to create a custom version of this UBE so that it doesn't prompt for Mode, Server and Days?
    EnterpriseOne 8.11 SP1
    WebSphere 6
    Oracle 10g

  4. #4
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,738

    Re: Periodic Maintenance - Clear Submitted Jobs

    Con,

    (from memory - please forgive me)....
    * Duplicate the called UBE - and make it do whatever you desire (add
    processing options, data selection and 'whatever' else you want to
    keep/purge).
    * The Calling UBE redirects the the Called UBE to a specified DataSource -
    you would copy this one, and change it to call your 'duplicated' UBE.

    Vahalla - you are done (after much testing and sacrifice).

    (db)

    On Tue, May 13, 2008 at 9:16 AM, Confounded <campbjj42-jdelist@yahoo.com>
    wrote:



    --
    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  5. #5

    Re: Periodic Maintenance - Clear Submitted Jobs

    [ QUOTE ]
    I've been running this manually every Monday from my fat client. Could you elaborate just a tad more on how one should be able to get this to work from the Scheduler? Would I need to create a custom version of this UBE so that it doesn't prompt for Mode, Server and Days?

    [/ QUOTE ]

    This is what I had in my notes:

    "You must have the target server in Logical Datasources in the Server Map for the environment (server?) in (on?) which the job (scheduler server?) is running"

    That used to read:

    "You must have the target server in Logical Datasources in the Server Map for the environment in which the job is running"

    I had ensured that the target server (the ES that was having its jobs cleared) had an entry in the Logical Datasources in the Server Map of the scheduler server (the ES on which the scheduled job ran).

  6. #6
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Location
    Toronto, Canada
    Posts
    2,146

    Re: Periodic Maintenance - Clear Submitted Jobs

    Confy
    Take a look at any existing scheduled batch version, and try to emulate it.
    Or maybe you do not use the Scheduler at all ...?
    Warm regards,
    Adrian,
    E1 9.1 TR 9.1.4.7 08-13-2014_07_7 MSQL 2012 SP1 x64, WebLogic 12c, all on WIntel 2012 x64
    3rd Party Software: All Out Security 3.2, TransForm 5.3, SAP Business Objects Enterprise XI 12
    In the Cloud!

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, Oracle or Peoplesoft.