Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Job Queue - stopped in...
Microsoft Dynamics NAV (Archived)

Job Queue - stopped in some companies

(0) ShareShare
ReportReport
Posted on by Y_NAV_1716 120

Hi all, 

we have a NAV 2017 database with around 15 companies and a job queue set in each that runs the same codeunit per company (CU 1281 - to automatically update the exchange rate). Lately we have experienced an issue where the job queue has stopped in some of the companies but not in others. The same exchange rate service is used in all the companies and all job queues run using the same user ID so I don't think that it is a user issue. One thing that I have also noticed is that in the companies in which the job queues have stopped, the log entries of the job queues have somehow disappeared as well. 

What other reasons could there be for the job queue to stop in certain companies but not in others? 

Any feedback would be appreciated :) 

Thanks! 

*This post is locked for comments

  • Suggested answer
    RockwithNav Profile Picture
    RockwithNav 6,562 on at
    RE: Job Queue - stopped in some companies

    Basically NAV job queue ends up with no specific reason, sometimes it changed to FINISHED with no specific reason and I also remember I also went up with the same SQL Job Concept.

  • Y_NAV_1716 Profile Picture
    Y_NAV_1716 120 on at
    RE: Job Queue - stopped in some companies

    Thanks ... will give the above a try! :)

  • Suggested answer
    TharangaC Profile Picture
    TharangaC 23,116 on at
    RE: Job Queue - stopped in some companies

    I have seen the same issue a couple of times and didn't found the root cause of it. To overcome the issue what we did was create a PS script to run the codeunit and then use that PS script and create a SQL Agent Job. This worked perfectly for us. 

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Job Queue - stopped in some companies

    Since you are not using a NAS server, make sure the Job Queue is started. Then check to make sure all the job queues are have an "Earliest Start Date/Time" in the future and the Job Queue Entry has a status of "Ready". Check the "General Ledger Setup" to make sure the GL period is open. Then check the "User Setup" to make sure the user can Post within that period.  

  • Y_NAV_1716 Profile Picture
    Y_NAV_1716 120 on at
    RE: Job Queue - stopped in some companies

    Thanks for your input:) We're not using NAS in this case, just the task scheduler. Any other ideas?

  • Suggested answer
    azelaya59 Profile Picture
    azelaya59 2,807 on at
    RE: Job Queue - stopped in some companies

    Are all the Job Queues setup with the same NAS Server? If not, change the Job Queues to the same NAS server. Bear in mind that when rebooting the server, you must restart the NAS instance from the Administration Client.  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans