To all:

Is there a way to do a mass delete of a large group (several THOUSAND) jobs for a single user in Lawson? I'm afraid I'm going to reach retirement age before I've completed the deletion of all of them through jobdef (we're still on LID).

Apps 8.0.3
Env 8.0.3
Unix
Oracle

Thanks in advance,
Laura P

Have a look at the jobinq utility. You can delete jobs in one foul swoop by user, product line, etc using that utility. Lawson has KB articles about it also.

Perfect! Exactly what I needed. I can't believe I've been working with Lawson for so many years and never used this before!

- LP

Follow it up with:
deljobhst -cjwrv -uUSERNAME 'curdate' - 1

This will clean up Completed Jobs, Recurring Jobs, Waiting Jobs and any batch report files that user has hanging around as well.

Lastly, use 'delusers' to remove the user from GEN

Thanks. We do run deljobhst VERY frequently as well as delusers. This was just a situation where a user ID was re-used for a different situation and thousands of old job definitions ONLY needed to be removed.

thanks again though for jobinq - that was VERY helpful!