Stored procedure that's currently running

0

Is there a system view that shows what stored procedures that are currently running?

  • What sql engine are we talking?

Ariel
已提問 7 個月前檢視次數 206 次
1 個回答
0

Hello, there is no specific system view which can show this information. However, once the stored procedure is called it will be visible in the STV_RECENTS [1] if its completed or STV_INFLIGHT [2] as once it is executed it will become treated as a normal query.

Alternatively, you can see the queries ran on the "Queries and Loads" tab on the console

Links: [1] https://docs.aws.amazon.com/redshift/latest/dg/r_STV_RECENTS.html [2] https://docs.aws.amazon.com/redshift/latest/dg/r_STV_INFLIGHT.html

AWS
支援工程師
已回答 7 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南