MaxCompute Lightning provides the system view stv_recents. You can use stv_recents to view all the query jobs that are running.
View all running query jobs
You can run a command to query the information of all running query jobs. The information includes the job ID, username, SQL statement, start time, duration, and resource waiting status. t indicates that the job is waiting for resources and is not executed. f indicates that the resources have been obtained and the job is being executed.
select * from stv_recents;
Cancel a running query job