Hi! I am given the task to check a huge list of jobs in different workflows, whether they have “earliest start” activated, doing it manually would take probably weeks, as they’re thousands. Is there any other way this could be done? Thank you!
select oh_name as Parent , isnull(jpp_alias, jpp_object) as Task , jpp_lnr as TaskNumber , JPP_ErlstStTime EarliestStartTimefrom jpp, ohwhere not jpp_erlststtime is nulland oh_idnr = jpp_oh_idnr and not oh_otype = 'JSCH'and oh_client = 100order by 1, 2, 3
(wrote this for SQLServer, AE V11.2.1)
* By manually I mean 1 by 1
Can you let us know for which product line is this for? (applications manager, dollar universe, automic workload automation etc..)?
Hi! Thank you for the response, and apologies for not including that -automic workload automation it is
Thank you for the information. As the post was in the CA Automic Community space, I have moved it to the CA Automic Workload Automation section/space to better reach the product user audience for inputs to your question.
You saved me a whole lot of time !
Retrieving data ...