How can I search for all batches that do not have an alert email?

[Mohammed_Alfassi_7915]

How can I write a script to search for all batches that do not have an alert email?

I am using One Automation 2013 

If someone can provide me the UC4 database documentation so I can write myself otherwise if someone have the script can share it with me.

[Pete Wirfs]

Do you mean you want to know what job objects in your UC4 system do not have an "Else Execute" on its Runtime tab?  This will find those objects;

select *

from uc4.dbo.oh

where OH_mrcExecute is null

and oh_otype in ('JOBS')

[Mohammed_Alfassi_7915]

Yes that what I meant. Thanks for your help.