Mass Delete Jobs? - LawsonGuru.com - LawsonGuru.com Forums -

Name	Points
Greg Moeller	4184
David Williams	3349
Kat V	2984
Woozy	1973
Jimmy Chiu	1883
Kwane McNeal	1437
Ragu Raghavan	1377
Roger French	1315
mark.cook	1244
Chris Martin	825

This_Guy

Veteran Member

Posts: 93

New Poster

1/7/2013 3:11 PM

Hey guys & gals... I know that you can use jobinq to review/edit/delete jobs one-by-one, but is there a way to mass delete these defined jobs? I have an active user that recently realized you dont need a new job for each and every possible scenario (she figured out how to user parameters! Finally!!) so she has many many many defined jobs for AP520. Is there a way to mass delete these? I suppose I could delete them from GEN tables, but wanted to see if there was a less daunting effort?

TJ Mann

Veteran Member

Posts: 70

1/7/2013 3:18 PM

deljobhst under that username will take care ALL jobs under that username.

This_Guy

Veteran Member

Posts: 93

New Poster

1/7/2013 3:23 PM

Thanks TJ, but doesnt deljobhst just delete the report/print mgr stuff? I am looking to mass delete her AP520 defined Job Names. The whole jobs themselves...

Greg Moeller

Veteran Member

Posts: 1498

MVP

New Poster

Engaged Reader

Avid Reader

1/7/2013 3:49 PM

Depends on the parameters that you use. Parameter j says 'Delete recurring job entries' or c says 'Delete completed job entries'

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

1/7/2013 3:58 PM

deljobhst just deletes history (job logs and print files).
There is not a command-line utility to mass remove jobs [without removing the user

]
Use jobinq -- it will display all jobs for a particular user, and you can delete the desired ones, all from one screen.

This_Guy

Veteran Member

Posts: 93

New Poster

1/7/2013 4:30 PM

Yeah, I know John. Its just a pain in the rectum, because each time I delete one, the cursor returns to the top of the list. And the jobs I am deleting are towards the middle/end. Ugh. Maybe I'll just do some SQL stuff in the GEN tables.... ??

TJ Mann

Veteran Member

Posts: 70

1/7/2013 4:39 PM

only if you know all tables holding that record. shoot me offline email. may be i can share you some of my shell scripts. mannt@email.chop.edu

John Henley

Posts: 3366

New Poster

Engaged Reader

Avid Reader

1/7/2013 5:09 PM

Press [Home] to mark all of the jobs, then [F9] / [B} to delete them

This_Guy

Veteran Member

Posts: 93

New Poster

1/7/2013 5:13 PM

Nice work John! Thanks...