Automic Workload Automation

Since this cannot be listed now even with the advanced search, i have created a sql statement which lists all objects within workflows which contain an earliest starttime.

select OH_Idnr, OH_Name, JPP_Object, JPP_ErlstStTime from JPP 
inner join OH on OH_Idnr = JPP_OH_Idnr 
where JPP_ErlstStTime is not NULL 
and JPP_Object = 'START' 
and OH_Client = 'xx' >>>>> there place clientnumber

you can add this e.g. to a SQLI Vara and click "Preview" to get a list of results, if you dont want to log in to a SQL Developer or Oracle Console.

You might want to remove the "and JPP_OBJECT = 'START'" clause so it really picks all tasks.

Definitely a useful query!

But it also selects schedule object rules, so I added this filter;

and OH_OType <> 'JSCH'