SQLTeam.com | Weblogs | Forums

How to write query get long process job or query or stored procedure running on server?

I work on sql server 2014
How to write query get long process job or query or stored procedure running on server ?

as example suppose i run
exec sp_joblong
how to know this procedure running now
and which place it stop and take long time
and how to know it finish execution on server

What have you researched and tried?

1 Like