Hi
I am afraid there is no way out of manually change e.g. workflows if an object inside has to be removed.
Please be careful when deleting objects, even if its inactive because the Workflow will stop in state "FAULT_OTHER" if an object is not found.
As a start you can use below SQL statements (Oracle) to identify 1) objects that were set to inactive and 2) Objects that were set to inactive on TASK level in the workflow
== Inactive Objects ==
select oh_name from oh
where oh_otype in ('JOBS','JOBP','JOBF','SCRI','JOBG','EVNT','JSCH','CALL')
and oh_inactive = 1
and oh_client = 666
and oh_deleteflag = 0
== Task Inactive within Workflow ==
select OH_NAME as "Workflow", JPP_OBJECT as "OBJ in WF", JPP_Lnr as "POS in WF", (CASE WHEN JPP_ACTIVE = 0 then 'not active, no breakpoint' WHEN JPP_ACTIVE = 1 then 'active, no breakpoint' WHEN JPP_ACTIVE = 2 then 'not active, with breakpoint' WHEN JPP_ACTIVE = 3 then ' active, with breakpoint' END) from OH, jpp
where OH_IDNR=JPP_OH_IDNR
/*
JPP_ACTIVE:
0 ... not active, no breakpoint
1 ... active, no breakpoint
2 ... not active, with breakpoint
3 ... active, with breakpoint
*/
and JPP_ACTIVE <> 1
and oh_client = 666
and oh_deleteflag = 0
hope this helps a bit
cheers, Wolfgang