Forum Discussion

vijay's avatar
vijay
New Contributor III
3 years ago

DataManagment job status

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 mo...
Data Management
  • NidhiMangtani's avatar
    NidhiMangtani
    3 years ago

    Hi,

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

     

    Hope this helps.

     

     

NidhiMangtani's avatar
NidhiMangtani
Contributor III
3 years ago

Hi,

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

 

Hope this helps.

 

 

  • NicolasArgente's avatar
    NicolasArgente
    Valued Contributor
    3 years ago

    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?

    • NidhiMangtani's avatar
      NidhiMangtani
      Contributor III
      3 years ago

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