Econix InfoTech

Business Central - Use Job Queues to Schedule Tasks

Dynamics 365 Business Central - Use Job Queues to Schedule Tasks

Use the Job Queue Entries page to schedule and run specific reports and codeunits. You can set jobs to run one time, or on a recurring basis. For example, you might want to run the Salesperson * Sales Statistics report weekly to track sales by salesperson each week, or run the Delegate Approval Requests codeunit daily to prevent documents from piling up.

The Job Queue Entries page lists all existing jobs. If you add a new job queue entry that will run on a schedule, you must provide some information. For example:

  • The type of object to run, such as a report or codeunit. You must have permission to run the particular report or codeunit.
  • The name and object ID of the object.
  • Parameters to specify the behavior of the job queue entry. For example, you can add a parameter to only send posted sales orders.
  • When, and how often, the job queue entry will run.

After job queues are set up and running, the status can change as follows within each recurring period:

  • On Hold
  • Ready
  • In Process
  • Error
  • Finished

After a job finishes successfully it’s removed from the list of job queue entries, unless it’s a recurring job. For recurring jobs, the Earliest Start Time field is adjusted to show the next time that the job will run.

Monitor status or errors in the job queue

Data that the job queue generates is stored, so that you can troubleshoot errors.

For each job queue entry, you can view and change the status. When you create a job queue entry, its status is set to On Hold. You can set the status to Ready and back to On Hold, for example. Otherwise, status information is updated automatically.

The following table describes the values of the Status field.

Status Description
Ready
The job queue entry is ready to be run.
In Process
The job queue entry is in process. This field updates while the job queue is running.
On Hold
The default status of the job queue entry when it's created. Choose the Set Status to Ready action to change the status to Ready. Choose the Set On Hold action to revert the status to On Hold.
Error
Something went wrong. Choose Show Error to show the error message.
Finished
The job queue entry is complete.

To view status for any job

  1. Choose the Lightbulb that opens the Tell Me feature. icon, enter Job Queue Entries, and then choose the related link.
  2. On the Job Queue Entries page, select a job queue entry, and then choose the Log Entries action.

View scheduled tasks

The Scheduled Tasks page in Business Central shows which tasks are ready to run in the job queue. The page also shows information about the company that each task is set up to run in. However, only tasks that are marked as belonging to the current environment can run.

For example, all scheduled tasks stop if the company is in an environment that’s a copy of another environment. Use the Scheduled Tasks page to set tasks as ready to run in the job queue.

The My Job Queue part

The My Job Queue part on your Role Center shows the job queues entries that you’ve started but aren’t finished. By default the part isn’t displayed, but you can add it to your Role Center. To learn more about personlization, go to Personalize Your Workspace.

The part shows the following information:

  • Which documents with your ID in the Assigned User ID field are being processed or are queued, including documents that are posting in the background.
  • Whether there was an error when posting a document or in the job queue entry.

The My Job Queue part also lets you cancel a document posting.

To view an error from the My Job Queue part

  1. On an entry with the status Error, choose the Show Error action.
  2. Review the error message and fix the problem.

Examples of what you can schedule using job queue entries

Schedule reports

You can schedule a report or batch job to run at a specific date and time. Scheduled reports and batch jobs are entered in the job queue and processed at the scheduled time, similar to other jobs. You choose the Schedule option after you choose the Send to action, and then you enter information such as printer, time and date, recurrence.

To learn more about scheduling, go to Scheduling a Report to Run

Schedule synchronization between Business Central and Dataverse

If you’ve integrated Business Central with Dataverse, the job queue lets you schedule when to synchronize data. Depending on the direction and rules you’ve defined, the job queue entry can create records in one app to match records in the other. A good example is when you register a contact in Dynamics 365 Sales, the job queue entry can set up that contact for you in Business Central. To learn more about scheduling, go to Scheduling a Synchronization between Business Central and Dynamics 365 Sales.

Schedule when to post sales and purchase orders

You can use job queue entries to schedule business processes to run in the background. For example, background tasks are useful when multiple users post sales orders at the same time, but only one order can be processed at a time. To learn more about background posting, go to To set up background posting with job queues.

Handle job queue entry issues

If a job queue entry shows an error, your first option to resolve the issue is to restart the job queue entry. You can set the status of the job queue entry to On Hold and then to Ready, or just restart it.

If a restart doesn’t help, the issue might be in the code. You can find the owner (also called the publisher) of the code in the AL stack trace in the Job Queue log. If the error comes from an app/extension, contact your Microsoft partner. If the error comes from a Microsoft application, open a support request with Microsoft.

If you contact your Microsoft partner or Microsoft for support, please provide the following information:

  • The ID of the job queue entry run where the error
  •  timestamp of when the error occurred
  • Your timezone

Monitor the job queue with telemetry

Administrators can use Azure Application Insights to gather and analyze telemetry that helps identify problems. To learn more about telemetry, go to Monitoring and Analyzing Telemetry and Analyzing Job Queue Lifecycle Trace Telemetry.

Telemetry lets administrators set up alerts on job queue issues that send a text message, email, or a message in Teams if something isn’t right. To learn more about these alerts, go to Alert on Telemetry.

LATEST INSIGHTS

REQUEST
FOR A CALL BACK
Provide discussion information and we’ll get back to you as soon as possible

GDPR and Consent Agreement

I consent to having this website store my submitted information so they can respond to my inquiry. Please read our privacy policy for more details.

Customer Satisfaction

Satisfaction
0%