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
preguntada hace 7 meses206 visualizaciones
1 Respuesta
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
INGENIERO DE SOPORTE
respondido hace 7 meses

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas