In hospitality in general, there is a great need for running jobs within the restaurants every few minutes or once every 24 hours when the business is either closed or there is little activity.
For KDS (Display and Printing)
For Offline Call Center (Call Center database)
For Offline Call Center (Restaurant database)
To configure the Task Scheduler
Data cleanup – KDS and statuses
To assign the Scheduler Job in the Hospitality Setup page
In a busy environment the datatables containing the KOT information fill up quickly and slow performance. Only the Meal Planning does not need to have the scheduler running, although the process that changes the POS menus by validation period could be run by the scheduler.
To run these jobs, a Task Scheduler has to be running on the Service Tier.
For Dining Table Management
| Job | Role | Codeunit | |
|---|---|---|---|
| Data Cleanup | To delete entries from the status tables and KDS tables older than a set number of days. Must be run to maximize performance. | Hosp. Status and KDS Cleanup | Run as a job (once a day, during closed hours) Job Queue Category: HOSP |
| Serv. Flow Status/Alert Upd | To update dining table status changes on timing and dining table alerts. |
Hosp. Service Flow Updates |
For KDS (Display and Printing)
| Job | Role | Codeunit | |
|---|---|---|---|
| Data Cleanup | To delete entries from the status tables and KDS tables older than a set number of days. Must be run to maximize performance. | Hosp. Status and KDS Cleanup | Run as a job (once a day, during closed hours) Job Queue Category: HOSP |
For Delivery & Takeout
| Job | Role | Codeunit | |
|---|---|---|---|
| Data Cleanup | To delete entries from the status tables and KDS tables older than a set number of days. Must be run to maximize performance. | Hosp. Status and KDS Cleanup | Run as a job (once a day, during closed hours) Job Queue Category: HOSP |
| Data Cleanup (Driver Trips) | To delete delivery driver trip entries order than a set number of days. | Delivery & Takeout Sched. Jobs | Run as a job (once a day, during closed hours) Job Queue Category: HOSP |
For Offline Call Center (Call Center database)
| Job | Role | Codeunit | |
|---|---|---|---|
| Get Estimated Timing | To get estimated timing information on orders from restaurants (how many orders are in progress, current average production time) | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
| Get Status on Orders | To get status information on orders from the restaurants. | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
| Data Cleanup | Delete entries in the web service log older than a set number of days. | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
For Offline Call Center (Restaurant database)
| Job | Role | Codeunit | |
|---|---|---|---|
| Process Call Center Orders | To send orders that have been sent from call center to the kitchen. | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
| Send Converted Pre-Orders to Call Center | To send orders after they have been converted to delivery or takeout orders back to the call center | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
| Data Cleanup | Delete entries in the web service log older than a set number of days. | Offl. Call Center Sched. Jobs | Run as a job Job Queue Category: OFFLINECC |
To configure the Task Scheduler
The Task Scheduler should be enabled when the Dynamics Business Central i installed.
-
Open the Microsoft Business Central Administrator for the Microsoft Dynamics 365 Business CentralIf the shortcut is not in the Start Menu, the applicaton can be located in the folder C:\Program Files (x86)\Microsoft Dynamics 365 Business Central\160\RoleTailored Client. The name is Microsoft Dynamics 365 Business Central Server.msc.
We assume the parameters for the Dynamics Business Central SQL server have already been set up correctly so the connection to the database has been established. Also remember to fill out the Services Default Company.
-
Open the Task Scheduler tab for the service you want to configure. If the checkbox 'Enable Task Scheduler' is not checked, check it and save the settings. And then restart the service tier.
This is enough for the Job Queue Scheduler to run
Job Queue Entries
The scheduler jobs that are used by the Job Queue are available in the demo data company. Use Import Export Worksheet to import available scheduler jobs. Use Insert Default Data to create the default jobs for Hospitality.
To insert default jobs for the Offline Call Centers go to the Offline Call Center Setup page and click the Insert Job Queue Entries action button.
Data cleanup – KDS and statuses
One scheduler job is needed for the KDS system and the hospitality status tables:
- KDS - Delete KOT Header
This clean-up job reads the Days Status and KOTs Exist in the Hospitality Setup page and deletes all KOTs that are older than 5 days, if the value in field Days KDS KOTs Exist is 5. The job deletes data in all KDS related tables, including the Hosp. Order Kitchen Status and the Hosp. Order KOT Status tables.
Note: To maximize performance, it is necessary to run this job once a day during closed hours.
Warning: When data in the KDS tables is deleted, it is not possible to run KDS reports for the deleted data. You will have to decide how far back you want to be able to use the reports and fill in the Days Status and KOTs Exist field accordingly.
This is an example of a Job Queue Entry for the KDS cleanup job.
To assign the Scheduler Job in the Hospitality Setup page
- Go to the Hospitality Setup page.
- In the Kitchen Display System FastTab, the Maintenance section, locate the Days Status and KOTs Exist field, and enter the number of days the KOT and status tables should exist.
- In the Delete Status and KOTs Job ID field, select the job with description KDS - Delete KOT Header.