Get last execution of store procedured

Last_Execution_Of_Store_Procedured.sql

SELECT CASE PS.database_id
		WHEN 32767
			THEN 'Resource DB'
		ELSE DB_NAME(PS.database_id)
		END AS [DB Name]
	,OBJECT_NAME(PS.object_id, PS.database_id) AS [SP Name]
	,PS.last_execution_time AS [Last Executed]
	,PS.execution_count AS [# runs]
FROM sys.dm_exec_procedure_stats PS
ORDER BY DB_NAME(PS.database_id)
	,PS.last_execution_time DESC