• 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!

Job to Purge Work Submitted Jobs display

Tom_Davidson

VIP Member
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
 

Larry_Jones

Legendary Poster
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
 

jgersic64

Active Member
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
 

MikeELUX

Member
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
 
Top