• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Infor / Lawson Platforms S3 Systems Administration

Mass Delete Jobs?

 8 Replies
 0 Subscribed to this topic
 27 Subscribed to this forum
Sort:
Author
Messages
This_Guy
Veteran Member Send Private Message
Posts: 93
Veteran Member
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 Send Private Message
Posts: 70
Veteran Member
1/7/2013 3:18 PM
deljobhst under that username will take care ALL jobs under that username.
This_Guy
Veteran Member Send Private Message
Posts: 93
Veteran Member
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 Send Private Message
Posts: 1498
Veteran Member
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
Send Private Message
Posts: 3351
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.
Thanks for using the LawsonGuru.com forums!
John
This_Guy
Veteran Member Send Private Message
Posts: 93
Veteran Member
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 Send Private Message
Posts: 70
Veteran Member
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
Send Private Message
Posts: 3351
1/7/2013 5:09 PM
Press [Home] to mark all of the jobs, then [F9] / [B} to delete them
Thanks for using the LawsonGuru.com forums!
John
This_Guy
Veteran Member Send Private Message
Posts: 93
Veteran Member
1/7/2013 5:13 PM
Nice work John! Thanks...