Does anyone have a query to tell me which objects will execute from a specific JSCH Object on a given day. Its simple enough to filter out inactive objects but how do I figure out which tasks will fulfill their calendar objects on a specific date?
do you have try to use the "Auto-Forecast" capability? It will provide you the information you are looking for.
AutoForecast on docs.automic.com.
Hope this help,
I'm looking into the Forecast feature now. I'd never used it. Unfortunately, i'm running into issue:
Error: U0011543 Structure of task 'C_PP_SD_DEPENDENCY_DIM_RSK_URL' is not ascending.
C_PP_SD_DEPENDENCY_DIM_RSK_URL, runs and and completes every day, not sure why it is breaking the forecast.
After the forecast completes I can view it, but nothing before 3am is shown.. not coincidentally I would assume, the Problem workflow above happens to be scheduled at 3am.
I use this query to report existing schedule-object rules;
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;
Retrieving data ...