TechNet
Export (0) Print
Expand All

sys.dm_broker_activated_tasks (Transact-SQL)

 

Updated: June 10, 2016

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

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

Column nameData typeDescription
spidintID of the session of the activated stored procedure. NULLABLE.
database_idsmallintID of the database in which the queue is defined. NULLABLE.
queue_idintID of the object of the queue for which the stored procedure was activated. NULLABLE.
procedure_namenvarchar(650)Name of the activated stored procedure. NULLABLE.
execute_asintID of the user that the stored procedure runs as. NULLABLE.

Requires VIEW SERVER STATE permission on the server.

Joins for sys.dm_broker_activated_tasks

FromToRelationship
dm_broker_activated_tasks.spiddm_exec_sessions.session_idOne-to-one

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

Community Additions

ADD
Show:
© 2016 Microsoft