E9.2 Check job status within orchestration

[ybuffetaud]

Hi I have made an archestration to launch an UBE via the BSFN B91300C, it will be used by our ETL (semarchy XDI) to manage for exemple our night processes.
I want to complete that with another orchestration that wille have the following entries:

• synchronous/asynchronous option : if synchronous we will check the status otherwise the orchestration will have to finish
• Limit duration in second : if synchronous is on we will check every 5 seconds the status in F986110 but if the limit time is reached we stop on put the orchestration on error for this reason

How to do that in an orchestration? Is it only a groovy script?

Regards

 

[Kevin Long]

I would suggest looking at the report service api on the AIS server. Get the Completion Status of a Report

You can access it using a REST connector pointing at your local AIS server. No groovy is required. You can define the json in the body of the connector and use text substitution ${} to pass in the job number.

 

[JohnDanter2]

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=388806160333139&parent=EXTERNAL_SEARCH&sourceId=HOWTO&id=2481191.1&_afrWindowMode=0&_adf.ctrl-state=zz3ye3may_4

Job # is in the output options

https://support.oracle.com/epmos/faces/DocumentDisplay?_afrLoop=388872272069675&parent=DOCUMENT&sourceId=2481191.1&id=2907063.1&_afrWindowMode=0&_adf.ctrl-state=zz3ye3may_53