Automic Workload Automation

  • Private Community

  • 1.  schedule details

    Posted Feb 01, 2018 03:18 AM
    Hi Everyone,

    I have 3 requirements from the AWA, Please check and suggest.

    1: Can we pull a report which shows all the objects under one work flow/schedule. (Parent Child Relationship)
    for example: if Schedule A has 1 workflow which contains 3 Jobs and One workflow within and the child workflow has 4 other jobs the a report pulled by schedule name should show the entire list of objects.

    2: Report for parent child relationship objects on basis of duration and job status
    (Statistic report which should show the job flow and their status for a time frame)

    3: a Calendar object report which should show the keywords in it as well
    so basically If we query to search a calendar object it should show the keywords too

    TIA
    Shani



  • 2.  schedule details
    Best Answer

    Posted Feb 01, 2018 04:14 AM
    ad 1: not by default, you can either click thru Statistics window "Child-Task-Statistics" or use my scipt posted here: https://community.automic.com/discussion/comment/29032#Comment_29032

    ad 2: you can change my script accordingly or click thru Statistics window "Child-Task-Statistics"

    ad 3: you can use this sql https://community.automic.com/discussion/9341/requete-sql-pour-retrouver-les-types-de-mots-cles
    i personnally would add the clause:
    and oh_deleteflag = 0
    and oh_client = 123

    SELECT OH_Name AS "Calendar", OKB_NAME AS "Keyword", CASE OKB_CTYPE
    WHEN 'S' then 'STATIC'
    WHEN 'W' then 'WEEKLY'
    WHEN 'R' then 'ROLL'
    WHEN 'M' then 'MONTHLY'
    WHEN 'Y' then 'YEARLY'
    WHEN 'G' then 'GROUP'
    END AS "Keyword type"
    FROM OH, OKB
    WHERE OH_Idnr=OKB_OH_Idnr
    and oh_deleteflag = 0
    and oh_client = 123
    ORDER BY OH_NAME;

    cheers, Wolfgang



  • 3.  schedule details

    Posted Feb 01, 2018 12:38 PM
    I don't know what you are working on, but I really like this report which lists all of our schedule object rules including calendar keywords;

    select oh_name           as SCHEDULE
          , jpp_object       as OBJECT
          , JPP_ErlstStTime  as STARTTIME
          , jppc_calekeyname as CALENDAR
       from uc4.dbo.oh
          inner join uc4.dbo.jpp 
             on oh_idnr = jpp_oh_idnr
          left outer join uc4.dbo.jppc 
             on jppc_jpp_lnr = jpp_lnr and jppc_oh_idnr = oh_idnr
      where oh_otype = 'JSCH' 
      order by 3,2,4;