How to extract categories of analytics jobs shown 'Edit Trigger' window in Job Control Panel

[DonovanPark]

I want to extract 'Analytics Categories' and 'Analytics Subcategories' attributes of RunAllAnalyticsJob job type in query of Analytics.

But, I couldn't find in docs. https://docs.saviyntcloud.com/bundle/EIC-Database-Schema-Reference/page/Content/Database-Schema-Refe...

in qrtz_triggers tables either.

I want to find it like these 'Disable', 'Terminate' values for each Jobs :

[rushikeshvartak · Accepted solution]

• select distinct category from analyticsconfiges

• select distinct SUBCATEGORY from analyticsconfiges

[DonovanPark]

I got it. Thank you!