Dear community,
is there any possibility to identify all manual toil jobs via sql query?
e.g. deliver all jobs/workflows/scripts which have been manually started (e.g. released from blocked, restarted etc.)
Unfortunately, I recognized that jobs which are in blocked state have AH_STATUS=0 instead of AH_STATUS=1898 (see https://docs.automic.com/documentation/webhelp/english/ALL/components/AE/11/All%20Guides/Content/ucaaiy.htm). Not sure if this behaviour is a bug or not.
Currently I'm using this query (Probably there will be some room for improvement):
SELECT ah_client AS CLIENT,
ah_idnr AS RUN_ID,
ah_name AS JOB,
ah_otype AS ObjectType,
To_char(ah_timestamp1, 'MM-DD-YYYY HH24:MI:SS') AS DateTime,
ah_status AS STATUS,
AH_RESTART AS RESTART_COUNTER
FROM uc4.ah
WHERE ah_timestamp1 >= To_char(SYSDATE, 'DD.MM.YY')
AND (AH_STATUS = '1850' OR AH_STATUS = '1851' OR AH_STATUS = '1899' OR AH_RESTART != '0')
AND AH_STATUS != '1900';
Regards