sys.dm_exec_background_job_queue_stats

execution
#execution#dmv

Description

Analytics Platform System (PDW) Returns a row that provides aggregate statistics for each query processor job submitted for asynchronous (background) execution. Number of requests successfully posted to the queue. Number of requests that started execution. Number of requests serviced to either success or failure. Number of requests that failed due to lock contention or Number of requests that failed due to other reasons.

Syntax

FROM sys.dm_exec_background_job_queue_stats;
GO