News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Any way to find all ba...

Finance | Project Operations, Human Resources, ...

Answered

Any way to find all batch jobs that use a particular class?

(0) Share

Report

Report

Posted on by JMajcen

17

Any system tables or other ways that can be used for this? Thanks!

All responses Img

All responses (2)

Answers Img

Answers (1)

JMajcen 17 on at

Like (1)

Report
RE: Any way to find all batch jobs that use a particular class?

This worked perfect. I coupled it with a join on the CLASSIDTABLE and got exactly what I was looking for.

SELECT a.BATCHJOBID , a.CAPTION , b.NAME FROM AxDB.dbo.BATCH a JOIN dbo.CLASSIDTABLE b ON a.CLASSNUMBER = b.ID WHERE b.NAME = 'CLASS_NAME'
Verified answer

André Arnaud de Cal... 294,060 Super User 2025 Season 1 on at

Like (0)

Report

RE: Any way to find all batch jobs that use a particular class?

Hi JMajcen,

The information is stored in the table 'Batch'. The class number is stored in this table. This is a number which correspondents to a class name in the application, but can be different per environment. You can use the DictClass class to get the number for a given class object name.

Helpful resources

News and Announcements

🌸 Community Spring Festival 2025 Challenge & Updates🌸

Quick Links

Leaderboard

#1

André Arnaud de Cal... 294,060 Super User 2025 Season 1

#2

Martin Dráb 232,858 Most Valuable Professional

#3

nmaenpaa 101,158 Moderator

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans