You don't need to run a query for this. You can get the information from the Definitions, Job view.
- Click the Filter (Funnel) icon to display the Job Rule Filter. Use the "Enabled" field to select enabled (Yes) or disabled (No) jobs.
- Right-click on Jobs and select Group Display, Expand All
- Right-click on Jobs and select Export and you can save the information to a .csv file
To limit the columns that display, right-click on Jobs and select Preferences. Select the columns you want on your list.
If you insist on running a query, something like this should work:
select jobmst.jobmst_prntname as 'Group'
, jobmst.jobmst_name as 'Job'
from jobmst
where jobmst.jobmst_active = 'Y' /* Y = enabled, N = disabled */
and jobmst.jobmst_dirty = '' /* exclude rows marked for deletion */
order by 1, 2
