Delete Update jobs

 4 Replies
 0 Subscribed to this topic
 18 Subscribed to this forum
Sort:
Author
Messages
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!

Is there a way to restrict the jobschd listing to only allow deletes of non-update jobs in the new Lawson security, or is that already built in? 

Looking at the security class, I only see All_Access or No_Access on the jobschd utility.

John Crudele
Veteran Member
Posts: 50
Veteran Member
New Poster
New Poster
Congrats on posting!
If you go under the GEN profile and "batch" security class you can modify the rules to the QUEUEDJOB table and remove the delete function.

We set-up two batch security classes one with the functionality and one without
Greg Moeller
Veteran Member
Posts: 1498
Veteran Member
MVP
MVP
You're an MVP!
New Poster
New Poster
Congrats on posting!
Engaged Reader
Engaged Reader
You are an engaged reader!
Avid Reader
Avid Reader
Avid Reader art thou!
Cool, John. Thanks for the help! I'll try that.
Joseph Carfagno
Basic Member
Posts: 10
Basic Member
That's good information. I implemented a rule on QUEUEDJOB to allow users to delete non-update jobs but not any others:

if(subString(table.Token,3,1) =='2')
'ALL_ACCESS,'
else
'I,A,M,'


Jobs in the 200 series may update the CKPOINT table but I don't believe that will be an issue. I'm curious if any others have implemented similar rules and what their experience is.
Deleted User
New Member
Posts: 0
New Member
Joseph-
I am using an identical script, and it has worked flawlessly for almost two years.