How to list jobs in Tidal that use run control overrides

[laehremet.mistry]

Hi

How do I get a list of jobs that use the run control overrides from the Database.

Thanks!

Laehr

[Derrick Au]

Hi Laehr

Try this SQL select statement:

select jobmst.jobmst_id, jobmst.jobmst_prntname, jobmst.jobmst_name, msglog.msglog_text from msglog
join jobmst on jobmst.jobmst_id = msglog.jobmst_id
where msglog.msglog_text like '%override%'
order by 2,3

BR,
Derrick Au