Restrict user from running Job Queue while another user is running it

(0) Share

Report

Posted on by Jatin Patel

2,641

Hi,

We have created one job queue entry using object type to run Codeunit. If someone runs this Job Queue and at the same time another user try to run it then it should gives warning message.

Ultimately we want to restrict it to single user. Any suggestions.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Simple, don't give the execute permission to everybody of this object.

Was this reply helpful? Yes No
Jatin Patel 2,641 on at

Like (0)

Report
Copy link

Link copied!

Thanks but if i give permission to two users and first user is running it and second user try to run then i want to restrict him/her.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

When an job queue is running it will be in Process, so i am not sure what issue you are experiencing how multiple users are running the same job, could you please explain your issue in detail.

Was this reply helpful? Yes No
Jatin Patel 2,641 on at

Like (0)

Report
Copy link

Link copied!

Users can create multiple job queue with same codeunit. We can't restrict to single job queue. If the one is running then others can't.

Was this reply helpful? Yes No
Suggested answer

Rajasekhar@MS 5,569 on at

Like (0)

Report
Copy link

Link copied!

Hi

When Creating / Running Job Queue i.e. before changing the Status of the Job Queue to Ready you can write the code to check whether the same code unit is running by some other User and throw error.

Regards

Rajasekhar.Y

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,269 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Jatin,

I don't there is any standard setup to stop users creating multiple job queues with same codeunit/object or running it.

You need to dothe customization on the job queue entry table on the Object ID To Run field validate check for duplicates and throw an error, so that you can restrict the users to have only one job queue for an object ID. This way you can restrict users creating multiple job queues for same codeunit and running it.

Was this reply helpful? Yes No
Suggested answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report
Copy link

Link copied!

Hey Jatin,

There is no setup or any other restriction available in the Default version of Microsoft Dynamics NAV. However if you really required to do this you can do a small modification to your code unit.

Before executing your code, check if there any entry with your Object ID in the Job Queue Entry table and if there is then throw an error.

However what is your intention of doing this? Even if several job queue entries been generated, Microsoft Dynamics NAV will run them one after the other and you won't have any problem.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

You can use any temporary table. When a user running the job queue then insert a line in that temporary table and when job queue will completed then empty the temporary table. Now when another user will try to run the job queue then let check is there any line in temporary table. If yes then error throws "job queue already running" else run the job queue.

Thanks & Regards

Niraj Kumar

niraj-msnav.blogspot.com

Was this reply helpful? Yes No