Active jobs on Data warehouse RRS feed

  • Question

  • Hello Team,

    Recently we observed that even when some copy activity of ADF is getting executed from an external source to data warehouse,

    executing the below query in data warehouse:

    SELECT * 
    FROM sys.dm_pdw_exec_requests 
    WHERE status not in ('Completed','Failed','Cancelled')
      AND session_id <> session_id()
    ORDER BY submit_time DESC;

    doesn't provide us with any output.

    So how are we supposed to get the active jobs(ADF copy activities) running to/fro from data warehouse.

    Tuesday, July 16, 2019 5:11 AM

All replies

  • Hello there,

    Are you copying from blob storage into the DW or from another SQL data source?

    You would only see the active jobs when the copy activity has started coping from blob storage (staging) into the DW.

    The copy job uses blob storage to stage data before copying into the DW.


    Tuesday, July 16, 2019 9:23 AM
  • Hi Priyaha,

    I am going to propose the answer provided by Piroinno. If you find a more specific answer to your situation please post that and mark as answered to assist those experiencing the same behavior. Thank you!

    Thursday, July 18, 2019 11:44 PM
  • Hi,

    I hope the information provided for your concern is helpful. Please "Mark as answer" if it was helpful, so that it can help the other users with same problem.

    If you need more information, please let us know.

    Tuesday, August 13, 2019 11:13 AM