cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
665
Views
0
Helpful
1
Replies
Highlighted
Beginner

SQL table that stores job enabled indicator

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!

1 REPLY 1
Highlighted
Enthusiast

Re: SQL table that stores job enabled indicator

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
CreatePlease to create content
Content for Community-Ad

Cisco COVID-19 Survey

This widget could not be displayed.