This week I needed to know if a stored procedure was running when expected during our batch. So, here is a quick couple of SQL to answer the question:
When a Stored Procedure was run last
This version of the SQL gives the date for the last time the Stored Procure was run:
| select distinct top 1 s.last_execution_time
from sys.dm_exec_query_stats s cross apply sys.dm_exec_query_plan (s.plan_handle) p where object_name(p.objectid, db_id(‘<<DATABASE_NAME>>’)) = ‘<<STORED_PROCEDURE_NAME>>’ Order by s.last_execution_time desc |
Get a list of when Stored Procedure has been run
This version of the SQL provides a list of dates of when Stored Procure has been run:
| select distinct s.last_execution_time
from sys.dm_exec_query_stats s cross apply sys.dm_exec_query_plan (s.plan_handle) p where object_name(p.objectid, db_id(‘<<DATABASE_NAME>>’)) = ‘<<STORED_PROCEDURE_NAME>>’ Order by s.last_execution_time desc |
Share this:
Discover more from Life Happens!
Subscribe to get the latest posts sent to your email.
