Purging Completed Jobs Work Centre Messages

john_holben

Member
<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>
 
John,

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


Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE
 
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 <[email protected]>
<DIV></DIV>>Reply-To: [email protected]
<DIV></DIV>>To: [email protected]
<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>>[email protected]
<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>
 
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
[email protected]
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 <[email protected]>
<DIV></DIV>>Reply-To: [email protected]
<DIV></DIV>>To: [email protected]
<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>
 
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
 

Similar threads

JohnDanter2
New Screen: Work Centre to Job # Link and UBE name / EDOC value search in Work Centre
Replies
0
Views
3K
JohnDanter2
JohnDanter2
JohnDanter2
E9.0 New Screen: Work Centre to Job # Link and UBE name / EDOC value search in Work Centre
Replies
0
Views
3K
JohnDanter2
JohnDanter2
JohnDanter2
E9.0 P012503 clone won't run online, works perfectly on local FAT
Replies
1
Views
3K
JohnDanter2
JohnDanter2
johndanter
Work Centre messages and their time stamp
Replies
3
Views
3K
peterbruce
peterbruce
DSauve
Disabling UBE Job Completion Messages in the JDE Work Center
Replies
3
Views
5K
Rauf
Rauf
Back
Top