Job Queue Entry Pattern
by Mark Brummel, Christopher Studebaker, David Studebaker, David Roys, Vjekoslav Ba
Microsoft Dynamics NAV
- Microsoft Dynamics NAV
- Table of Contents
- Microsoft Dynamics NAV
- Microsoft Dynamics NAV
- Credits
- Preface
- 1. Module 1
- 1. Exploring Microsoft Dynamics NAV – An Introduction
- Understanding Microsoft Dynamics NAV
- The functional areas within Dynamics NAV
- History of Dynamics NAV
- Functional areas
- Accessing Dynamics NAV
- Summary
- 2. What's New in NAV 2016?
- Application changes
- Improvements for the application users
- Tablet client
- New application features
- Automatic payment and bank reconciliation
- Signing up for the Bank Data Conversion Service
- Reconciling payments automatically
- Reconciling bank statements automatically
- Social Listening
- Power Business Intelligence
- RapidStart services
- Schedule reports
- E-mailing documents
- Document exchange service (OCR Services)
- Exchange rates update
- Native integration with Dynamics CRM
- Universal app
- Workflow management
- Posting Preview
- Deferrals
- Development changes
- IT changes
- Summary
- Application changes
- 3. Dynamics NAV – General Considerations
- 4. The Implementation Process – From the Reseller
- 5. The Implementation Process on the Customer Side
- 6. Migrating Data
- Tools to migrate data
- RapidStart Services
- Using XMLports to migrate data
- Writing your own tools
- Converting data from the old system to Dynamics NAV's needs
- Master data
- Open entries
- Historical data
- Open documents
- Choosing a go-live date
- Summary
- Tools to migrate data
- 7. Upgrading Microsoft Dynamics NAV
- Upgrading philosophy
- Upgrades prior to Dynamics NAV 2013
- Upgrades from Dynamics NAV 2013 forward
- Upgrading process checklist
- Upgrading steps to NAV 2013
- Upgrading tools
- Summary
- 8. Development Considerations
- 9. Functional Changes on Existing Implementations
- 10. Data Analysis and Reporting
- 11. Debugging
- 12. Popular Reporting Options with Microsoft Dynamics NAV
- 1. Exploring Microsoft Dynamics NAV – An Introduction
- 2. Module 2
- 1. An Introduction to NAV 2015
- NAV 2015 – an ERP system
- Significant changes in NAV 2015
- A developer's overview of NAV 2015
- Hands-on development in NAV 2015
- Summary
- Review questions
- 2. Tables
- An overview of tables
- Enhancing our sample application
- Creating and modifying tables
- Assigning a Table Relation property
- Assigning an InitValue property
- Adding a few activity-tracking tables
- New tables for our WDTU project
- New list pages for our WDTU project
- Keys, SumIndexFields, and table relations in our examples
- Modifying a standard table
- Version list documentation
- Types of tables
- Summary
- Review questions
- 3. Data Types and Fields
- 4. Pages – The Interactive Interface
- Page design and structure overview
- Types of pages
- Page Designer
- Page components
- WDTU Page Enhancement – part 1
- Page controls
- WDTU Page Enhancement – part 2
- Page Actions
- Learning more
- Summary
- Review questions
- 5. Queries and Reports
- Queries
- Reports
- Report components – overview
- Report data flow
- Report components – detail
- Creating a Report in NAV 2015
- Summary
- Review questions
- 6. Introduction to C/SIDE and C/AL
- 7. Intermediate C/AL
- 8. Advanced NAV Development Tools
- NAV process flow
- Role Center pages
- XMLports
- Web services
- Summary
- Review questions
- 9. Successful Conclusions
- Creating new C/AL routines
- Multi-language system
- Multi-currency system
- Navigate
- Debugging in NAV 2015
- C/SIDE Test-driven development
- Other Interfaces
- NAV Application Server (NAS)
- Client Add-ins
- Customizing Help
- NAV development projects – general guidance
- Design for efficiency
- Updating and upgrading
- Supporting material
- Summary
- Review questions
- 1. An Introduction to NAV 2015
- 3. Module 3
- 1. Introducing Dynamics NAV Patterns and Software Architecture
- What do we mean by 'patterns'?
- Microsoft Dynamics NAV Design Patterns
- Patterns elements and hierarchy
- Building blocks
- Metadata
- Base application
- Summary
- 2. Architectural Patterns
- 3. Design Patterns
- 4. Building an Example Application Using Patterns
- 5. Coding Best Practices
- 6. Anti-patterns and Handling Legacy Code
- 7. Building Solutions Using Patterns
- 1. Introducing Dynamics NAV Patterns and Software Architecture
- Bibliography
- Index
In Microsoft Dynamics NAV, processes can be automated using the Job Queue. The Job Queue asynchronously processes requests as a background service using an NAV Application Service.
Note
An explanation of the implementation of Job Queue Entry Pattern is available at https://www.youtube.com/watch?v=UA2Pq7fv-Dk&list=PLhZ3P-LY7CqmVszuvtJLujFyHpsVN0U_w&index=15.
Most processes can be wrapped in a Job Queue process by implementing Job Queue Entry Pattern.
Job Queue Pattern requires us to wrap the process into a Codeunit that takes a Job Queue Entry as a parameter. This Codeunit then follows a number of steps.
The Job Queue Entry contains a Record ID that allows us to read a record from a specific table. This record will be the one to be processed.
In this step, we execute the automated process. Each process in Dynamics NAV should be designed to be wrapped in a Job Queue Entry, and should therefore avoid any runtime decisions; or if any, they should be omitted.
Try to avoid the code cloning of the main function to allow running via the Job Queue Entry.
The following illustrates the structure of the Job Queue Entry Codeunits:
Specific tasks related to the background process can be handled in this step, such as handling the Job Queue Status.
The source table for the automated process should have a new field Job Queue Status. This field is of the type Option, and has the options: (blank), Scheduled for Posting, and Error & Posting.
The Helper Codeunit, as discussed in the pattern Document History, should set this field to the Scheduled for Posting value when the background processing is activated.
-
No Comment