sys.dm_broker_activated_tasks (Transact-SQL)

Applies to: SQL Server

Returns a row for each stored procedure activated by Service Broker.

Column name	Data type	Description
spid	int	ID of the session of the activated stored procedure. NULLABLE.
database_id	smallint	ID of the database in which the queue is defined. NULLABLE.
queue_id	int	ID of the object of the queue for which the stored procedure was activated. NULLABLE.
procedure_name	nvarchar(650)	Name of the activated stored procedure. NULLABLE.
execute_as	int	ID of the user that the stored procedure runs as. NULLABLE.

Permissions

Requires VIEW SERVER STATE permission on the server.

Permissions for SQL Server 2022 and later

Requires VIEW SERVER PERFORMANCE STATE permission on the server.

Physical joins

Relationship cardinalities

From	To	Relationship
dm_broker_activated_tasks.spid	dm_exec_sessions.session_id	One-to-one

Next steps

Dynamic Management Views and Functions (Transact-SQL)
Service Broker Related Dynamic Management Views (Transact-SQL)