SQL table that stores job enabled indicator

[louiegomez1005]

Hi folks,

Does anyone know which specific SQL table and column on the Admiral database contains the info whether a job is enabled or disabled?  We would need to run a SQL query to generate a report on a daily basis.

Thanks in advance!

[Derrick Au]

This is an old posting...

select * from jobmst where jobmst_active = 'Y' // for enabled jobs
select * from jobmst where jobmst_active = 'N' // for disabled jobs