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)
Feedback
https://aka.ms/ContentUserFeedback.
Binnenkort beschikbaar: In de loop van 2024 zullen we GitHub-problemen geleidelijk uitfaseren als het feedbackmechanisme voor inhoud en deze vervangen door een nieuw feedbacksysteem. Zie voor meer informatie:Feedback verzenden en weergeven voor