Job Queue in Microsoft Dynamics NAV 5.0

IntroductionWith Microsoft Dynamics NAV 4.0 we had a job scheduling mechanism available in the Service Management module. The purpose for the job scheduler in Microsoft Dynamics NAV 4.0 is to give the possibility for scheduling tasks and their recurrence. In Microsoft Dynamics NAV 5.0 the Job Queue was introduced. The Job Queue is primarily made…

1

How to Set Up Job Queue in Microsoft Dynamics NAV 5.0

The Job Queue is handling the order of batch jobs and code units that are setup to run at a given time. The application server reads from the job queue and determines what job to run next. Several parameters can be set up to determine this. Prerequisites Before you can setup and execute a job…

1

Job Queue Example in Microsoft Dynamics NAV 5.0

What if all posting routines in Microsoft Dynamics NAV could be scheduled to a more sufficient time of the day? The example in this blog shows how the job queue functionality can be used to allow background posting of sales orders. In this example the sales order will contain creation of a new field that…

2

Finding Index usage

When troubleshooting performance problems, a typical questions is: “which indexes can be disabled on SQL”? This blog shows a simple way to get some ideas of which indexes are used. The method will give some ideas of both how often they are updated (causing overhead), and how often the indexes are actually used. So it…