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
gefragt vor 7 Monaten206 Aufrufe
1 Antwort
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
SUPPORT-TECHNIKER
beantwortet vor 7 Monaten

Du bist nicht angemeldet. Anmelden um eine Antwort zu veröffentlichen.

Eine gute Antwort beantwortet die Frage klar, gibt konstruktives Feedback und fördert die berufliche Weiterentwicklung des Fragenstellers.

Richtlinien für die Beantwortung von Fragen