Automic Workload Automation

Expand all | Collapse all

how to query database for calendar/keywords used in schedules/tasks

  • 1.  how to query database for calendar/keywords used in schedules/tasks

    Posted 15 days ago
    How can I query the database for usage of calendar/keywords in schedules, jobp tasks, etc?  Want a list of calendar/keywords where used in other objects (schedules, workflow tasks, etc).


  • 2.  RE: how to query database for calendar/keywords used in schedules/tasks

    Posted 15 days ago
    Here is a query I use to "dump" all of our schedule rules, including objects that don't use a calendar rule.  I hope it helps?

    select oh_client as client
    , 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 4,3,5;

    ------------------------------
    Pete
    ------------------------------



  • 3.  RE: how to query database for calendar/keywords used in schedules/tasks

    Posted 15 days ago
    Hummm...  This won't give you everything you are looking for.  My query only lists the rules that are inside of JSCH objects.   Each task in a workflow can have its own calendar rules as well.  Don't think I have a query for that.

    ------------------------------
    Pete
    ------------------------------