Dynamics User Group
Since 1995 - The Microsoft Dynamics Online User Community

December 2007 - Microsoft Dynamics NAV Sustained Engineering Team Blog

Sort by: Most Recent | Most Viewed | Most Commented

  • Job Queue in Microsoft Dynamics NAV 5.0

    Introduction With 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 for Outlook Integration, but has been extended to also include the previous job scheduling mechanism from Microsoft Dynamics NAV 4.0. The purpose of the...
    Filed under:

  • 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 queue you will need to: 1. Install Microsoft Dynamics NAV 5.0 2. Install Microsoft Dynamics NAV Application Server a. Make sure that the NAV user is registered in NAV and on the SQL Server, if SQL Server is...
    Filed under:

  • 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 indicates if the sales order has been scheduled for posting. A filter is also introduced, so that the user doesn’t see Sales Orders that are scheduled. We will also create a Job Queue entry for every...

  • 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 gives some ideas of costs and benefits for each index. SQL2005 introduced the concept of Dynamic Management Views (DMVs), which show internal statistics from a lot of different...
    Filed under:

Copyright Dynamics User Group, 1995-2008, all rights reserved. The Dynamics User Group is not affiliated with Microsoft Corporation.