Automic Workload Automation

Expand all | Collapse all

JOBF select count in AH_NAME

  • 1.  JOBF select count in AH_NAME

    Posted 08-01-2017 09:52 AM
    Hi,
    How do I to count (select count AH_NAME) only the 'main jobf', for example, JOBF.TEST without counting the same jobf that has only change file name after transfer?
    How to count?
    Example:
    JOBF.TEST
    JOBF.TESTE(/SFTP/TESTE_01-09-2015.CSV)
    JOBF.TESTE(/SFTP/TESTE_02-09-2015.CSV)
    JOBF.TESTE(/SFTP/TESTE_03-09-2015.CSV)

    I using the following select:

    select count(AH_Name), AH_Name from AH where AH_OType in ('JOBS', 'JOBF') and AH_Client='0110' and to_char(AH_TimeStamp4,'yyyy-mm-dd HH24:MI:SS') between '2017-07-31 03:00:00' and '2017-08-01 02:59:59' group by AH_Name order by AH_Name

    Thanks and regards,
    Karina





  • 2.  JOBF select count in AH_NAME

    Posted 08-02-2017 05:31 AM
    Not sure I fully understood, but:

    Since the main JOBF never has brackets in the name (guaranteed as per Automic object naming constraints), but the "child" JOBF always have, wouldn't the following additional "where" clause not suffice?

    ... where AH_NAME not like '%(%'

    Best,
    Carsten


  • 3.  JOBF select count in AH_NAME

    Posted 08-02-2017 09:02 AM
    Hi Carsten_Schmitz_7883 ,

    Yes, this is my doubt.
    Thank you for your answer!

    Best Regards,
    Karina