Automic Workload Automation

 View Only

Identify manual interventions via SQL Query

  • 1.  Identify manual interventions via SQL Query

    Posted Jun 30, 2020 02:05 PM
    Edited by Michael TMO8Y2tl Jun 30, 2020 04:01 PM

    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