Automic Workload Automation

Expand all | Collapse all

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

Jump to Best Answer
  • 1.  How can I search for all batches that do not have an alert email?

    Posted 05-03-2016 04:37 AM
    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.


  • 2.  How can I search for all batches that do not have an alert email?
    Best Answer

    Posted 05-03-2016 01:26 PM
    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')


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

    Posted 05-04-2016 04:05 AM
    Yes that what I meant. Thanks for your help.