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

[Karen French]

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).

[Pete Wirfs]

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
------------------------------

[Pete Wirfs]

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
------------------------------