The
Search function in the Automation Engine does not appear to allow one to search for SQLI VARA objects based on the content of the queries stored in those objects. To work around this limitation, I came up with an SQL query that does the trick.
select * from OH
join OVD on OVD_OH_IDNR = OH_IDNR
where 1=1
and OH_Client = 120
and OH_DeleteFlag = 0
and OH_OType = 'VARA'
and OH_SubType like 'SQLI%'
--and OH_Name like '%'
and OVD_SQLORA like 'with orig_job as%'
Enjoy!