Allow user to view their own server jobs only

Hi List,

I have a situation whereby users would like to know their job status [ie. how many more jobs before theirs is processed] but mgt would not allow users to view other users pdf, due to sensitive data in certain reports. Currently we blocked users to only be able to view their own jobs thus they are kept guessing about their job status. This is pretty inconvenient especially when we have multiple jobs queues but user cannot check which queue is available. We are on ERP8.

Pls advise if this is achievable? Thanks in advance!

Assuming you've not done anything nasty like apply row security to limit the view in the job table (most people just lock the user field on the application), I'd suggest just creating a custom application that returns only the information you want from the job control table, with a data selection set to a staus of W and perhaps P. You don't need to return all the columns either, probably just queue, status, perhaps job, user, and job number. You wouldn't even need to create a BV, use the same one the P986110B uses.

Regards,

Interesting approach, thanks for sharing.

You could create a custom report with the following SQL:

use JDE7334

select * from SVM7334.F986110 where JCJOBSTS='W'


Code this report to run in a separate queue on its own so that it does not get caught behind other jobs.

Optimizing your queues/threads so that jobs don't back up would help eliminate the root cause of the problem. Move long running jobs into a seperate queue.

Thanks for your input.