Skip to main content

How to Use - Job Queue Parameter String?

Hi All,

Today we will discuss about the Parameter String Field in Navision Job Queue Entry Page / Form. 

The Functionality is still same, so the steps below can be replicated and used in NAV Classic also. For Demo Purpose We will be using NAV 2013 R2.

Why we need to have a Parameter?

Consider a Scenario where you want to does multiple things with a single objects in NAS based on parameter you pass. Example - There should be different action on the sales Header Table based on Parameter that I Pass.

So Let's see how to use the Parameter String in Job Queue.

For the Demo, I have created the Job Queue & Job Queue Category List as DEMO.

Now for Demo, I am creating two Tables Demo Customers and Demo Items. The Job Queue will insert Record in these tables based on the parameter that I pass.

The Important Thing to Remember about Parameter String to be used with Job Queue is -
"The Object Should be Running with the Record of Job Queue Entry Table."

We Will be using a Codeunit for the Demo, Go to Properties of OnRun Trigger and Enter the TableNo as 472.

Let's now write condition for the parameter that will be passed by Job Queue. We will be using two functions for creating dummy customer and dummy items based on parameter passed. These functions will be called based on Parameter String Passed.

As Shown below we are done with conditionally executing code based on parameter passed by user.

Let's set-up the Job Queue Entries for Both the Cases as shown below -

IF you see above except the Parameter String, everything else remain Same. So when the first (left) Job is executed an Customer is created and When Second (Right) Job is executed an Item is created.

Let's try to Execute the Job With Item First and see the Results -

Now Let's try to run the Job having Cust as Parameter -

Think of the situation where you can use it. Like Running Batches with Filters.

Hope you find the post useful.

Your Questions and Comments are awaited.

Saurav Dhyani


  1. Hi Saurav,
    Please I need your assistance on workflow user group, with 12 users where only 6 user is needed. I meant how to setup it workflow, thanks
    my gmail account:


Post a Comment

Popular posts from this blog

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

NAV 2013 R2 - Cumulative update 12 Released.

Hi all, Please find below the details of  Cumulative Update 12 released for Microsoft Dynamics NAV 2013 R2. Title - Cumulative Update 12 for Microsoft Dynamics NAV 2013 R2 Build No. - 38053 Release Date - October, 2014 Local Version Included - AU, AT, BE, CH, DE, DK, ES, FI, FR, IS, IT, NA, NL, NO, NZ, SE, UK, RU Download Link Note: Implementing this cumulative update will require a database conversion unless you have already implemented update rollup 5.

NAV 2013 Upgrade Part III - Data Upgrading.

Hi all, As per agenda we need to discuss the data upgrade in NAV 2013. The process is similar to what used to be till NAV 2009 R2 but with some changes. Let's start the process. Remember -  1) You can only upgrade a database to NAV 2013 from NAV 2009 SP1 / R2 SQL Only. 2) The Synchronization of users with SQL Server is no more required.