Is your feature request related to a problem? Please describe.
Part of: #89429

As part of our effort to migrate to a multi-tenant architecture, we need to ensure our existing cancel statement diagnostics report endpoint is tenant-scoped.

Fortunately, the existing endpoint is implemented using SQL, meaning the remaining work to be done is implementing the same endpoint for our tenantAdminServer.

Reference PR: #84620, making the Jobs and Job endpoints tenant-scoped

Jira issue: CRDB-20671