Extract UC4 workflows & jobs

[Kishore Kumar]

Hi Team

Could you pls help us to extract the list of UC4 Workflow & Job names.

Also If possible, How the workflow & jobs are scheduled & at what time.

Thanks

[Pete Wirfs]

This will extract all JOBP and JOBS types of objects.  You'll probably want to adjust it to also select scripts, events, and other types of executable objects as well;

select *
from   oh
where  oh_deleteflag = 0
and    oh_otype in ('JOBP', 'JOBS')​

I like to use this SQL query to identify all tasks that are scheduled via a JSCH object;

select oh_client as client
     , oh_name as SCHEDULE 
     , jpp_object as OBJECT
     , JPP_ErlstStTime as STARTTIME
     , jppc_calekeyname as CALENDAR
from oh
inner join jpp 
     on oh_idnr = jpp_oh_idnr
left outer join jppc 
     on jppc_jpp_lnr = jpp_lnr and jppc_oh_idnr = oh_idnr
where oh_otype = 'JSCH' 
order by 4,3,5;​

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

[David Ainsworth]

Hi @Kishore Kumar
is there a reason you are not using the forecast functionality of Automic to predict "How the workflow & jobs are scheduled & at what time".
Which version of Automic are you running?

cheers
David

​

------------------------------
Head of Product Management, Automic Automation
CA Technologies, A Broadcom Company
------------------------------

[Kishore Kumar]

Hi @David Ainsworth

Here is the automic version. I'm new to Automic tool. 

We need to extract the complete list of JOBP & JOBS. It would be great if you help on this step by step details.

Thanks
Kishore 

​

[David Ainsworth]

Hi @Kishore Kumar
what is the use case for listing all the jobs and workflows?
 
​@Pete Wirfs already gave you some SQL​

I am suggesting you use the forecast function to predict when everything is planned to execute.

David

------------------------------
Head of Product Management, Automic Automation
CA Technologies, A Broadcom Company
------------------------------