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…


Overview of Microsoft Dynamics NAV W1 5.0 SP1

I have often been asked about the content of Microsoft Dynamics NAV W1 5.0 SP1.I will here give a short overview of what we are planning to include in servicepack 1 for Microsoft Dynamics NAV 5.0, please be aware that the scope can still change: 1.       Product improvements More than 300 product improvements based on feedback…

3

New trace flag in Update 4 for SQL 2005 SP2

The current release cycle for SQL 2005 SP2, is to release a new update every 2-3 months. Currently (November 19th 2007), the latest update for SQL 2005 SP2, is update 4, which is available here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;941450 The updates for SQL 2005 SP2 are all accumulative, so you will not have to install Updates 1 –…


How to use the new Employee Portal with Microsoft Dynamics NAV 4.0 SP3

The Released Employee Portal can also work with NAV 4.0 SP3. If you want to run the new employee portal with NAV 4.0 SP3, you need to turn off the compression. This is because the compressions work differently on .NET Framework 1.1 and 2.0. Normal communication and encrypted communication is working fine. Partners will have…

0

Employee Portal for Microsoft Dynamics NAV 5.0

I am pleased to announce the update of Employee Portal for Microsoft Dynamics NAV 5.0. This update is now available for you to download at PartnerSource ,login credentials are required. Employee Portal for Microsoft Dynamics NAV 5.0 includes all the known functionality from earlier versions of Employee Portal and in addition supports Windows SharePoint Services 3.0 (WSS…

1

Platform Roll-up Update for Microsoft Dynamics NAV 5.0

I am pleased to announce that the first platform update is now available for Microsoft Dynamics NAV 5.0. You can receive the Platform Roll-up Update for Microsoft Dynamics NAV 5.0 KB943858 by requesting it here, just fill in the KB number (943858) and submit the request. This update contains a wide number of error corrections for…

0

Diagnose your SQL Server

I assume that anyone reading this will be very familiar with collecting traces with SQL Server Profiler. And be equally familiar with the two main limitations of SQL Server Profiler: It adds a big overhead to SQL Server, which is the last thing you need when troubleshooting performance problems, and How to make sense of…