Automated processes and job queues
As ERP manager you must regularly step into the engine room and verify that the automated processes in Business Central are running as they should. Business Central performs many tasks automatically in the background: invoices are sent, reports are generated, data is synchronized. When everything works, nobody notices. If a process fails and nobody catches it, the consequences grow hour by hour.
What a job queue is
In Business Central you can automate tasks with job queues. A job queue is a scheduled task that runs automatically, either once or at a fixed frequency. You decide:
- what should run
- when it should run
- how often it should repeat
Classic examples of job queues
| Task | Why the job queue is clever |
|---|---|
| Invoice dispatch | You post invoices throughout the day. The job queue sends them together, for example in the evening. |
| Approval emails | Notifications to approvers are pushed out by a job queue. If the job queue stops, approvals pile up. |
| Heavy reports | An inventory valuation report that takes time to calculate can be generated overnight and sit in the Role Center inbox in the morning. |
| Exchange rates from a central bank | The job retrieves rates daily. If it fails, Business Central uses outdated rates. |
Plan job queues with care
Job queues that run too frequently, or that perform heavy calculations while many users are signed in, can affect performance.
Consider whether heavy jobs can run outside working hours, for example at night or early in the morning. That reduces the risk that users experience delays, and it reduces the risk of locking conflicts in the database where the job and a user try to update the same data at the same time.
New job queue architecture from 2024
In 2024 Microsoft fundamentally changed how the job queue works:
- the queue now functions as an actual queue (FIFO)
- jobs are processed in sequence
- urgent jobs can be prioritized and moved up
How job queues fail
Job queues can fail for many reasons:
- an email address is missing for an email dispatch
- a job that should retrieve exchange rates from a central bank can’t reach them
- an integration doesn’t get a response from the system it is trying to talk to
- a posting can’t complete because of an error in the configuration
Business Central marks the job as failed, and you can quickly see what the problem is.
The problem is when nobody looks
Imagine that the invoice dispatch job queue has stalled on a Monday and nobody catches it. By Friday you have five days of invoices that never reached the customers. Payments are delayed, and you now have to figure out which invoices need to be sent.
Put monitoring into a system
Make it a fixed routine to check your job queues, like a machinist checking that everything is running properly.
Daily, weekly, and monthly checks
Put your operational checks into a system with fixed cadences. Introduce:
- daily checks of critical jobs
- weekly checks of less critical jobs
- monthly checks of jobs that run rarely
That way you know exactly how often each process should be checked, and your colleagues can trust that operations are running well.
Delegate the responsibility where it makes sense
You can delegate some of the responsibility. The finance department usually has the discipline to perform regular checks. Other departments may not. Someone needs the task of monitoring the operational processes, and you need a plan for what happens if a process hasn’t run.
The cleanup task after an error is almost always larger than the inconvenience of checking regularly.
Notifications for failures: three options
You can set up notifications that alert you when a job queue fails:
| Notification channel | How you set it up |
|---|---|
| Built-in notification in Business Central | Use the setup guide “Configure Job Queue Notifications”. Choose who should be notified when a job fails. |
| Email and phone notification | Connected to Power Automate, so you get a notification without being signed in to Business Central. |
| Display on the Role Center | Failed job queues are shown directly on the Role Center. Requires a Role Center that supports it. |
Make monitoring a natural part of everyday work
The Role Center display is a simple way to make monitoring a natural part of your everyday work. You have the overview immediately when you sign in in the morning, rather than having to remember to actively go and look.