Skip to main content
V
vijay
Newcomer
May 24, 2022
Solved

DataManagment job status

  • May 24, 2022
  • 2 replies
  • 0 views

hi,

i have a long running DM job which was triggered from ControlM using the REST API. The problem is controlM couldnt wait for the DM job completion to mark it as completed since the DMjob takes more than 2 hours to complete. Can we write a seperate function which sends back the DM job status from OneStream so that controlM can polls and check for the DM job completion. Is there an API method available which gives out the status of the DM job.

 

Thanks

Vijay

 

Best answer by NidhiMangtani

Hi,

Can you try accessing the system database table "TaskActivity" and check for endtime for your data management sequence?

 

BhartiParyani_0-1653482449404.png

Hope this helps.

 

 

2 replies

N
NidhiMangtaniAnswer
Veteran
May 25, 2022

Hi,

Can you try accessing the system database table "TaskActivity" and check for endtime for your data management sequence?

 

BhartiParyani_0-1653482449404.png

Hope this helps.

 

 

N
NicolasArgente
Veteran
May 25, 2022

Good point! You can do a custom SQL query on this table that filters on the status of the DM job. Then you host this query in another API and the job is job right?

N
NidhiMangtani
Veteran
May 25, 2022

Yes, I have never queried system database tables though. Please let me know if this works.

V
vijayAuthor
Newcomer
May 25, 2022

We have increased the timeout of API to  6 hours from 1 hour and it solved the 521 http error. Thanks all for your help  

Terms & ConditionsAccessibility statement