Create email alert notification when batch job is executing for more than 1 hour

(0) Share

Report

Posted on by Community Member

I want to send email alert notification when my batch job is executing for more than 1 hour in D365FO

I have the same question (0)

All responses (9)

Answers (1)

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

I Don't think this is possible in out of box.

Why do you want yo achieve this?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

My sales packing slip batch job is taking very long time to execute due to others batch jobs are forced to kept on hold until sales packing slip batch job is completed. My requirement is to send an email alter notification whenever batch job is executing for more than 1 hour.

Was this reply helpful? Yes No
Suggested answer

Ramit Paul 22,797 Most Valuable Professional on at

Like (0)

Report

Hi,

I understand,

It can be dealt by different way as well.

Please investigate if some batch is taking long time and that affects this execution.

We have seen "Customer aging batch" takes long time and it affected other batches as taking long time, in your case that can be different.

Yo may need to tune your environment such as "Staging data clean-up", database index rebuilt etc.

If required, please take help from MS support team as they have your database access and suggest you for tuning.

Was this reply helpful? Yes No
Verified answer

nmaenpaa 101,160 Moderator on at

Like (2)

Report

If you need such alert, I see two options.

1) Develop a new batch job in D365. The job would analyze all batch jobs which are in status Executing. If such job was started more than 1 hour ago, you could send out a Business Event / Alert.

2) Create a Power Automate flow that reads BatchJobEntity in D365, and analyzes if it's been running for more than an hour. If you choose this approach, I recommend reading only the one batch job that you are interested in. For example, if your Packing slip batch starts every night at 21:00, your Power Automate flow could trigger daily 22:00 and check if the batch job is still Executing. If yes, send out an email.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

The suggestions from Nikolaos are great. However, you should also check why the batch would take a lot of time. On LCS environment monitoring, you can review SQL activity for e.g. long running queries.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Nikolas,

Thanks for the guidance. Option 2 looks great.

Could you please help me with any blogs having information/process on power automate that reads Batch jobs in D365?

Regards,

Akshay

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

I think you can look into any documentation about connecting Power Automate with D365 F&O. The fact that you need to connect to Batch job info doesn't impact the overall process.

It's good to try to learn it on a general level, then you can apply your knowledge to any entities.

Was this reply helpful? Yes No
André Arnaud de Cal... 301,075 Super User 2025 Season 2 on at

Like (0)

Report

Hi Akshay,

I created some blogs about Power Automate and the Dynamics 365 Fin and Ops connector. However, it is not having a direct example with batch jobs: dynamicspedia.com/.../

Was this reply helpful? Yes No
Suggested answer

Junaid Idrees on at

Like (0)

Report

Hi Microsoft Dyanmics D365FO,

Just thinking loudly, If your packing slip batch job is taking long time and you are forced to hold other important batch jobs then you should investigate the root cause of this issue instead of sending an email to administrator to notify if it took 1 hour or not but still your actual problem is not solved yet.

I suggest You should create specific batch group for packing slip batch job with dedicated batch server to speed up the posting or do the complete analysis of this activity and figure out why it is taking too long.

Was this reply helpful? Yes No