RKL eSolutions Blog Trends and Insights

How to Receive Notifications on a Batch Job Error in Sage X3

If you're tired of receiving notifications for every successful completion of a recurring task and only want to be alerted in case of an error, you're in luck. Here's a step-by-step scenario on how to set up a workflow rule specifically designed to notify you when a job finishes with an error.

Creating an Alert When a Job Finishes with an Error

To create an alert that sends you a message when there's an error in your recurring task, you'll have to create a new workflow rule that references said task. In this scenario, I'll be creating a rule to send an alert when the recurring task "Stock Accounting Interface (ZFUNSTKACC)" has an error.

To set up a workflow rule, navigate to All > Setup > Workflow > Workflow rules.  In this example, I've entered the following:

  • Code - YENDREQ
  • Description - FUNSTKACC Error Email
  • Category - EXP (check "Active")

Workflow Rules - Trigger Event is End of Task (1-3)

The key to setting up an alert for when a job finishes with an error lies in the Conditions. By using the Batch Server Queries table, you'll be able to monitor the flag status of any running jobs and trigger the alert when an error occurs.

To create a condition for batch jobs in this example, I've entered the following:

  • Table code - ABATRQT
  • Abbreviation - ABR
  • Description - Batch Server (queries)

Set Batch Server Condition (2)

Condition should check flag status of the jobs that run (3)

The formula for my condition is "[F:ABR]FLAG=6 or [F:ABR]FLAG=7 or [F:ABR]FLAG=8".

Formula for the Condition Set May Result in Multiple Operations and Variables (4)

In the Recipient column, enter the e-mail addresses of whoever should be notified in case of an error, along with the message and any action you wish them to take.Select the Recipients for each condition (5-1)

Want More Sage X3 Features & Functions?

For more Sage X3 videos, head over to our YouTube page and subscribe to stay up-to-date with the latest insights and tutorials. Our channel is dedicated to providing valuable resources for businesses looking to optimize their financial management with Sage X3.

question-markCheck out these blogs to help get you started!

4 Functions to Use in the Preventative Maintenance Solution
How to Match Tolerances
How to Prevent Users from Cloning Documents
How to View Multiple Lines When Running an Inquiry

Tags: Sage X3, How-To
Amy Powell

Written by Amy Powell

Amy is based out of Florida working as a Senior Solution Architect on our Sage X3 team. With her 25+ years of experience, she specializes in process manufacturing and discrete manufacturing ERP implementations.