• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Purging Completed Jobs Work Centre Messages

<html>

Does anyone know the name of the purge UBE that removes Sumitted Jobs messages in Work Centre?</P>


I currently run the following each week:</P>


Purge Completed Tasks R01131P</P>


Purge Completed Processes R98860P</P>


These remove completed process instance and activity instance messages as stated in the JDE documentation, but do not remove Submitted Job messages that are successful or completed.</P>


</P>


Any help much appreciated</P>


Drowning in Submitted Job messages...</P>


John</P><br clear=all><hr>Get your FREE download of MSN Explorer at http://explorer.msn.com
</p></html>
 

Larry_Jones

Legendary Poster
John,

please include your OneWorld Version, platform, etc so that we (the list) may better assist you.


Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 

Chad_Anderson

Active Member
John
Are you setting the processing option for R01131P to "Purge all tasks regardless of status"? That should fix your problem.

Hope this helps
Chad

And as always, please include your system info in your signature!!

Chad Anderson
Generac Portable Products L.L.C.
B733.1 SP 7.1 AS400 Ent NT SQL Deploy
 
<html><DIV>


B7332/SP10.1/NT4.0/SQL7.0

I called JDE on this issue and they said that there is no existing report to purge Submitted Jobs messages, so will have to create our own UBE based on R01131P</P></DIV>
<DIV></DIV>
<DIV></DIV>>From: Larry_Jones <LJONES@WAGSTAFF.COM>
<DIV></DIV>>Reply-To: jdelist@jdelist.com
<DIV></DIV>>To: jdelistml@jdelist.com
<DIV></DIV>>Subject: Re: Purging Completed Jobs Work Centre Messages ~~5325:5331
<DIV></DIV>>Date: Fri, 9 Feb 2001 07:29:50 -0800 (PST)
<DIV></DIV>>
<DIV></DIV>>John,
<DIV></DIV>>
<DIV></DIV>>please include your OneWorld Version, platform, etc so that we (the list) may better assist you.
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>Larry Jones
<DIV></DIV>>ljones@wagstaff.com
<DIV></DIV>>OneWorld B733.1, SP 11.3
<DIV></DIV>>HPUX 11, Oracle SE 8.1.6
<DIV></DIV>>SandBox: OneWorld XE
<DIV></DIV>>--------------------------
<DIV></DIV>>Visit the forum to view this thread at:
<DIV></DIV>>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=&Board=OW&Number=5331
<DIV></DIV>>*************************************************************
<DIV></DIV>>This is the JDEList One World / XE Mailing List.
<DIV></DIV>>Archives and information on how to SUBSCRIBE, and
<DIV></DIV>>UNSUBSCRIBE can be found at http://www.JDELIST.com
<DIV></DIV>>*************************************************************
<DIV></DIV>>
<DIV></DIV><br clear=all><hr>Get your FREE download of MSN Explorer at http://explorer.msn.com
</p></html>
 

Larry_Jones

Legendary Poster
John,

1) Ignore Response Line's answer regarding purging of Work Center Messages - R01131P will work very well to clear all work center messages (including those about submitted jobs) IF you use the Purge by Date processing option.

2) Is it possible you are thinking of something else? There is also a "Submitted Jobs" form that displays the status of current and past jobs submitted to run on a server. You access this either from the "Work With Servers" application (P986116) or from the "Submitted Jobs" Form Exit on the "Work With Batch Versions" screen. The submitted jobs listed here do not in fact have a working purge program (as of B7331 anyway). It is very easy however to write your own as only one table (F986110) is involved. This is the approach we took here. We wrote our own UBE to purge the table F986110 of records older than 30 days. An accompanying O.S. shell script is run nightly to delete .pdf and .log files in the server printqueue and log directories older than 30 days.

Regards,

Larry Jones
ljones@wagstaff.com
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 
<html><DIV>


Chad</P>


I tried thisbut it does not appear to make a difference when trying to clear out Submitted jobs messages.
</P>


John
B7332/SP10.1/NT4.0/SQL7.0</P></DIV>
<DIV></DIV>
<DIV></DIV>>From: Chad_Anderson <CHAD_W_ANDERSON@YAHOO.COM>
<DIV></DIV>>Reply-To: jdelist@jdelist.com
<DIV></DIV>>To: jdelistml@jdelist.com
<DIV></DIV>>Subject: Re: Purging Completed Jobs Work Centre Messages ~~5325:5340
<DIV></DIV>>Date: Fri, 9 Feb 2001 08:40:56 -0800 (PST)
<DIV></DIV>>
<DIV></DIV>>John
<DIV></DIV>>Are you setting the processing option for R01131P to "Purge all tasks regardless of status"? That should fix your problem.
<DIV></DIV>>
<DIV></DIV>>Hope this helps
<DIV></DIV>>Chad
<DIV></DIV>>
<DIV></DIV>>And as always, please include your system info in your signature!!
<DIV></DIV>>
<DIV></DIV>>Chad Anderson
<DIV></DIV>>Generac Portable Products L.L.C.
<DIV></DIV>>B733.1 SP 7.1 AS400 Ent NT SQL Deploy
<DIV></DIV>>--------------------------
<DIV></DIV>>Visit the forum to view this thread at:
<DIV></DIV>>http://198.144.193.139/cgi-bin/wwwthreads/showflat.pl?Cat=0&Board=OW&Number=5340
<DIV></DIV>>*************************************************************
<DIV></DIV>>This is the JDEList One World / XE Mailing List.
<DIV></DIV>>Archives and information on how to SUBSCRIBE, and
<DIV></DIV>>UNSUBSCRIBE can be found at http://www.JDELIST.com
<DIV></DIV>>*************************************************************
<DIV></DIV>>
<DIV></DIV><br clear=all><hr>Get your FREE download of MSN Explorer at http://explorer.msn.com
</p></html>
 

Chad_Anderson

Active Member
John
Just to make sure we are talking about the same thing, by "work center submited jobs" you mean the messages that are stored in the F01131 table? If not then my suggestion will probably not work.

Just trying to help.

Chad Anderson
Generac Portable Products L.L.C.
B733.1 SP 7.1 AS400 Ent NT SQL Deploy
 
Top