Which tasks will run from JSCH object for given date.

[Adrian Stubbs]

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?

[Legacy User]

Hi Adrian,

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,

Franz

[Adrian Stubbs]

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.

[Pete Wirfs]

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;